Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Derived Graph

Hi Guys.

Question about qlikview functionality.

Is there any way to create graph based on columns which placed in pivot table.

I mean use pivot table like data source?

4 Replies
Not applicable
Author

Hi, You'll not be able to directly point the graph to output of the pivot table but you could use the formula of the pivot table to drive the same result in graph.

If you can explain your scenario or post sample data, it would be helpful for us to suggest you the best way.

- Sridhar

Not applicable
Author

the problem is formulas in source pivot table is realy complex.

And i can't imagine how write all things in one formula

This is ABC XYZ analysis

ABC-Analysis.png

I need create table with summarized data

     Number of products,    X, Y , Z

A                                            

B

C

ABC calculations based on Accumulation of percent of sales

All products sorted by Amount of sales and after thats we can calculate category

XYZ category determining like standart deviation of previous periods in my case its three months

I need something like this http://de.wikipedia.org/wiki/ABC/XYZ-Analyse

Not applicable
Author

As far as i know, will not be able to point the pivot table output data to another graph. you need to look for a way to achive your requirement usiing the formulae only.  if you can post the sample data and the o/p you required. will try to find you the solution.

- Sridhar

maksim_senin
Partner - Creator III
Partner - Creator III

Hi Vladimir,

Did you succeed to build ABC-XYZ ranking on-the-fly? Or you selected a solution based on use of load script?

Thanks.

Best regards,

Maxim