I have the same question as QVVLlogin. ABC over one dimension seem to be solved ok by Qlikview but the challenge is how to combine ABC for two or more dimensions. E.g. We want to see ABC by Sales Value compared with ABC by Contribution, Volume, Frequency etc. Extremely useful and powerful type of analysis.
I have attached a spreadsheet that shows the concept and what we are trying to achieve.
1) Is it possible to achieve this in a dynamic analysis in Qlikview, if so, how?
2) If a static classification must be done during load script, how would this script look like?
ABC_ABC_Example.xls 16.5 K
Don't know how this can be achived with set expression or functions but.
I think this logic can be implemented in load script in following way
1. Create several tables with ABC per Sales, Units, e.t.c.
2. Joining tables by ProductName
3. Creating a chart
But how about different type of selection?
Is that's analisys?
Maybe we can fill tables mentioned in the begining with ABC calculations diring partial reload to decrease calculation time ?
this can be done with VB macro
But like for me it's realy tricky.