Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

how to get chart from pivot table

Serial_NOModel
1A
2B
3C
4D
5A
6FA
7G
8A
1A
1A
2B
4D
5A
Pivot table
Serial_NOCOUNT SERIALMODEL
12A
21B
42D
52A

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 :

table.png

3 Replies
vikasmahajan
Esteemed Contributor

Re: how to get chart from pivot table

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

Not applicable

Re: how to get chart from pivot table

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:

table.png

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

Hi,

Can you post your sample APP.

Regards

ASHFAQ

Community Browser