Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
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...