Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

$ used in calculated dimension

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

3 Replies
Kushal_Chawda

Actually outer $ evaluates the expression as inner $ just represents the IF statement as String

Peter_Cammaert
Partner - Champion III
Partner - Champion III

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

mayankraoka
Specialist
Specialist

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