topic Derived Graph in QlikView

Derived Graph

Mon, 26 Jan 2026 18:19:17 GMT

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?

Derived Graph

Wed, 01 Jun 2011 13:04:20 GMT

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

Re: Derived Graph

Wed, 01 Jun 2011 13:10:10 GMT

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

I need create table with summarized data

Number of products, X, Y , Z

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

Re: Derived Graph

Wed, 01 Jun 2011 13:17:19 GMT

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

Re: Derived Graph

maksim_senin — Thu, 12 Apr 2012 05:05:52 GMT

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