topic Re: Expression for pivot chart in QlikView

Expression for pivot chart

tamilarasu — Tue, 17 Mar 2015 07:57:27 GMT

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.

Output should like I mentioned in pink color.

Header Title like >>> Price & [Currency]

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

Thank you in advance

Gysbert_Wassenaar — Tue, 17 Mar 2015 09:32:32 GMT

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

tamilarasu — Tue, 17 Mar 2015 10:00:00 GMT

Hi Gysbert,

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

Gysbert_Wassenaar — Tue, 17 Mar 2015 10:02:32 GMT

No, an expression label can have only one value.

tamilarasu — Wed, 18 Mar 2015 04:33:45 GMT

Gysbert. For the the clarification.