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)