4 Replies Latest reply: Jun 5, 2014 9:56 PM by jagan mohan rao appala RSS

    if statement in qlikview expressions

      Hi there,

       

      I am creating an analysis dashboard. Since the currency rate does not include 1 for US Dollars, I need to write an If statement for the sales in US$ across the stores around the world. Since store ID 1,16, 19 are all using US dollars, the expression I wrote is :

       

      If (StoreID=1 or 16 or 19, sum(sale), sum(sale/rate)).  But when I double check, say Japanese store, the result returned to me is still sum(sale) instead of sum(sale/rate). Can someone tell me what goes wrong here?

       

      Thank you so much!

       

      Best Regards,

       

      Gloria