topic Re: pivot table with multiple expression in QlikView

pivot table with multiple expression

jeevays7 — Mon, 26 Mar 2018 13:51:17 GMT

Hi All,

I have two table like below.

Table 1 :

Table 2:

and I need the output in the pivot table like below chart.

Result:

In the above chart, Exp2 is sum(Value2) and Exp3 is Sum(Value3) and Sum(Value) is for A,B,C(this is field values of NAME).

How to do this?

sunny_talwar — Mon, 26 Mar 2018 13:56:14 GMT

This?

jeevays7 — Mon, 26 Mar 2018 13:58:13 GMT

Yes, Sunny. Please share how to do?

sunny_talwar — Mon, 26 Mar 2018 13:59:18 GMT

Are you using personal edition of QlikView? If not, then you can open up the attached qvw.... or do you not understand something I did

jeevays7 — Mon, 26 Mar 2018 14:04:07 GMT

Thank you sunny. i got it.

sunny_talwar — Mon, 26 Mar 2018 14:04:45 GMT

Super

jeevays7 — Mon, 26 Mar 2018 14:08:16 GMT

Hi Sunny, I have a doubt.

Can we do without creating "Dim" Field in backend?

For example: Valuelist('2','3') like that?

sunny_talwar — Mon, 26 Mar 2018 14:23:03 GMT

I don't think so... but give it a shot and let us know what you find

govind1501 — Wed, 20 Nov 2019 08:12:50 GMT

not able to download file 296078.qvw.Can you please help me.

dennysetiawan — Thu, 04 Nov 2021 03:41:35 GMT

If I follow to your solution, it makes my Pivot Table run very slow.

Can you give another workaround for more better performance?