This content has been marked as final. Show 3 replies
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