Discussion board where members can get started with Qlik Sense.
I am using the FilterPane in Qlik Sense Desktop and I currently have columns called Days and Price:
Is there a way to have my Price columns show this instead of its actual values:
Greater Than One
Less Than One
All I need is everything sorted out that if i choose the "Greater Than One" option, it will show:
Solved! Go to Solution.
You can do this in the script:
If(Price < 1, 'Less Than One', 'Greater Than One') as PriceFlag
or you can use an expression for the list box
If(Price < 1, 'Less Than One', 'Greater Than One')
If(Price < 1, 'Less Than One', 'Greater Than One') as PriceFlag;
LOAD * INLINE [