Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Champion
Champion

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
Author

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..

ashfaq_haseeb

Hi,

Can you post your sample APP.

Regards

ASHFAQ