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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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