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: 
Scott2
Creator
Creator

QlikSense - Add more than one measure to a cell in a Pivot Table? Add Indicators?

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?

Scott2_1-1692888969282.png

 

and is it possible to include an Indicator with a measure in a Pivot Table like the below screenshot?

Scott2_2-1692889361601.png

 

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

 

Labels (1)
1 Reply
ajaykakkar93
Specialist III
Specialist III

Hi,
In a single measure, you can concat multiple measures & get the below output

ajaykakkar93_0-1692942265165.png

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.

 

Please mark the correct replies as Solution. Regards, ARK
Profile| GitHub|YouTube|Extension|Mashup|Qlik API|Qlik NPrinting