pivot table with multiple expression

[jeevays7]

Hi All,

I have two table like below.

Table 1 : 

ID	NAME	Value
1	A	4
1	B	5
1	C	6
2	A	2
2	B	4
2	C	5
3	A	3
3	B	5
3	C	3

Table 2: 

ID	Value2	Value3
1	50	70
2	60	80
3	70	90

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

Result:

ID	A	B	C	Exp2	Exp3
1	4	5	6	50	70
2	2	4	5	60	80
3	3	5	3	70	90

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 · Accepted solution]

This?

[jeevays7]

Yes, Sunny. Please share how to do?

[sunny_talwar]

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]

Thank you sunny. i got it.

[sunny_talwar]

Super

[jeevays7]

Hi Sunny, I have a doubt.

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

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

[sunny_talwar]

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

[govind1501]

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

[dennysetiawan]

Hi @sunny_talwar 

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

Can you give another workaround for more better performance?