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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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...