Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

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

Derived Graph

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

Re: Derived Graph

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

Re: Derived Graph

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

maxim_senin
Contributor III

Re: Derived Graph

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

Community Browser