topic Re: how to get chart from pivot table in QlikView

how to get chart from pivot table

Thu, 04 Sep 2014 09:17:46 GMT

Serial_NO	Model
1	A
2	B
3	C
4	D
5	A
6	FA
7	G
8	A
1	A
1	A
2	B
4	D
5	A
Pivot table
Serial_NO	COUNT SERIAL	MODEL
1	2	A
2	1	B
4	2	D
5	2	A

Is it possible to get this pivot chart in to a chart(in the pivot table not all serial numbers and models are taken due to a script but this is not necessary), because if i now make the chart i will get all the data from the complete table and this i dont want :

Re: how to get chart from pivot table

vikasmahajan — Thu, 04 Sep 2014 09:50:15 GMT

In Chart you can select tick from General Tab - > Fast Change option can be convert pivot into chart

please refer pic for setting.

Hope this helps you

Vikas

Re: how to get chart from pivot table

Thu, 04 Sep 2014 09:59:32 GMT

Unfortunately it doesn't show the good values.

first i need to count all the same models which are in the pivot table and then plot that...

now i get this:

as you can see in the last listbox i get 191 but i want only the sum of the selected models in the pivot table(now you see only one model) but if i have more models i want to sum/count all the same models and plot this in to a chart..

Re: how to get chart from pivot table

ashfaq_haseeb — Thu, 04 Sep 2014 10:39:56 GMT

Hi,

Can you post your sample APP.

Regards

ASHFAQ