3 Replies Latest reply: Jun 23, 2014 1:27 PM by Gloria Zhou RSS

    sum statement with two conditions

      Hi There,

       

      I successfully loaded a master calendar with Year, Month and Day which reflects order date. I want to find the total sales in previous year when currency code is USD.

       

      The expression I am using is Sum({<[CurrencyCode]={'USD'},OrderDate={=MakeDate(Year-1,num(Month),Day)}>}Sale), but Qlikview returns me an error.

       

      Can anybody tell me what went wrong and how to fix it? Thanks so much!

       

      Best Regards,

       

      Gloria