3 Replies Latest reply: Oct 30, 2014 7:35 PM by Stefan Wühl RSS

    Case statement in Load script

      Hi,

      i'm new to qlikview, can we write a case statement in Load script  as we do in the sql select statement? when i try to write the below script its giving me syntax error, can someone please help me in solving this.

       

       

      CASE WHEN (Product ='Toys')

      THEN ([Revenue]+[Tax]+[GP]) ELSE

      ([Revenue]) END TotalRevenue