Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set Analysis for IF statement

Can you please help me on the following IF statements to convert to SET ANALYSIS in QLIKView

IF (Transaction_Value =100 then 10 * 2

IF (Transaction _Value = 200 then 10 * 3

IF( Transaction status in ( Clearing, Authorised) then OK))).

Thanks

Ben

10 Replies
Anonymous
Not applicable
Author

Sorry, cannot guess because don't know what's in your variables.  It may be

$(vfive)

vfive

'$(vfive)'

$(=vfive)

See this blog, maybe it helps :http://community.qlik.com/blogs/qlikviewdesignblog/2013/11/04/the-magic-of-variables

And just try a little...