Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello ,
I was analyzing an expression built by some other developer.
There is some if condition in a variable,
say , var1=if (var=20,'ABCDEF','VWXYZ')
now we are showing this in calculated dimesnion like
$(=$(var1))
the inner dollar evaluates value, what about other outer dollar.
Thanks
Khushboo
Actually outer $ evaluates the expression as inner $ just represents the IF statement as String
Not entirely.
The "inner dollar", upon evaluation, will replace the inner $() stuff with the current content of the var1 variable. Leading to something like:
$(=if (var=20,'ABCDEF','VWXYZ'))
Only then, the "outer dollar" will be replaced with the result of evaluating the IF expression (as caused by the leading equal sign).
Best,
Peter
Hi Khushboo,
The answer to your query is well explained in the below blog:
https://community.qlik.com/blogs/qlikviewdesignblog/2015/09/28/dates-in-set-analysis
Regards,
Mayank