9 Replies Latest reply: Oct 29, 2018 8:45 AM by Avinash Chettipalli RSS

    Problem with Qlik expression

    Siva Sankar Boggarapu

      Hi All,

       

       

      I have table in Qlik sense. The table contains customer, Start date, Expiry date and CBM value.

       

      Before filtering any selections its showing 42.66 Values. But after I am making selection its showing 47.11(correct value )

       

      After I filtering, I am getting correct value. Before filtering I am getting different value.Below is the expression I wrote.

       

      Please let me know what is the wrong.

       

      Sum({<[acct_dt]={">=$(=(Min(Date([Start Date of Rate Validity]))))<=$(=(Min(Date([Expiry Date of Rate Validity]))))"},[Product Code]={'OFREXP'},[Sub Product Code]={'OFLCL'}>}CBM)

       

       

      Thanks,

      Siva