Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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...