Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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