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: 
dunnalahk123
Creator III
Creator III

Varibale Not working

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.

4 Replies
asinha1991
Creator III
Creator III

does your variable definition have '=' ?

dunnalahk123
Creator III
Creator III
Author

Hi,

 

i have attached my application  in original discussion.

Wilson_Webb
Partner - Contributor II
Partner - Contributor II

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.

Wilson_Webb
Partner - Contributor II
Partner - Contributor II

Alternatively you can just add an = sign to your definition