Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community!
I'm hoping you can help this newbie with another Pivot Table question...
In QlikSense Is it possible to add more than on measure to a Pivot Table like the below screenshot?
and is it possible to include an Indicator with a measure in a Pivot Table like the below screenshot?
fyi - I dont want to colour the text. I am aware how to colour the background using an expression so can handle that part.
Thanks!
Scott
Hi,
In a single measure, you can concat multiple measures & get the below output
sum(....) &' '& sum(....)&' ('&
num(sum(....)/sum(....),'#0%') &
if( num(sum(....)/sum(....),'#0') > 0.6 , 'up arrow','down arrow' )
&' )'
Replace with your expression in a single measure.
Indicator:
up arrow: chr(9644)
down arrow: chr(9660)
NOTE: Total might not work as intended.