Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Can some one help why variable is not working when i pass it in Chart Dimension as expression
i have created a variable as
vUserLog
Chr(39) & UPPER(OSUser() ) & Chr(39)
below is what i am giving in my Dimension expression.
if(NTNAME=$(vUserLog),Employee_Full_Name,'XXXXXXX')
it is working on text box work when i give $(vUserLog) but same its not working in Chart dimension.
For your reference i am attaching my Qlikview.
does your variable definition have '=' ?
Hi,
i have attached my application in original discussion.
Hi There,
Please can you use:
=if(NTNAME =vUserLog,Employee_Full_Name,'XXXXXXX')
This is due to the fact that you did not use the '=' sign in the definition. Which is correct. Just in the front end a normal expression works differently to dimensions.
Alternatively you can just add an = sign to your definition