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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
tamilarasu
Champion
Champion

Expression for pivot chart

Hi,

I have data like below. In that currency is differ for each country. Now, I want to create a expression like below in the header field alone.                       

Capture.PNG

Output should like I mentioned in pink color.


Header Title like >>> Price & [Currency]  


Capture.PNG


Can anyone give me expression for this. I have attached sample file.

Thank you in advance

1 Solution

Accepted Solutions
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Why can't you simply add the Currency dimension to the pivot table?

comm156315.png


talk is cheap, supply exceeds demand

View solution in original post

4 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Why can't you simply add the Currency dimension to the pivot table?

comm156315.png


talk is cheap, supply exceeds demand
tamilarasu
Champion
Champion
Author

Hi Gysbert,

Thanks for the response. I tried this but I am expecting the result as I mentioned. Is it possible?

scratching-head-smiley-emoticon.gif

Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

No, an expression label can have only one value.


talk is cheap, supply exceeds demand
tamilarasu
Champion
Champion
Author

hi-hand.gifGysbert.  signboard-thank-you-smiley-emoticon.gifFor the the clarification.