Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Carlaf_93
Creator II
Creator II

drop down variable

Good morning,

 

i would like to show yes if a value is 0 and no if it is 1 in a drop down variable.

How should i write it?

concat(field,'|') ??? 0~ yes, 1~ no

1 Solution

Accepted Solutions
Kushal_Chawda

@Carlaf_93  you can create fixed values like below

Screenshot 2020-10-26 114618.png

View solution in original post

2 Replies
Gabriel
Partner - Specialist III
Partner - Specialist III

@Carlaf_93 

Maybe try 

=IF(GETFIELDSELECTIONS(FieldName)='Yes',0,1)

 

Kushal_Chawda

@Carlaf_93  you can create fixed values like below

Screenshot 2020-10-26 114618.png