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,