topic Re: ABC Cross analysis in QlikView

ABC Cross analysis

Anonymous — Tue, 18 Feb 2014 15:08:13 GMT

Hi guys,

I'm trying to figure out how to show a dynamic calculated ABC Cross analysis (by Invoiced value and Margin Value) in the same table. In the attached file you can find a simple example with sample data as below:

I'm able to show ABC Analysis into two different tables:

I'm not able to show the above percentages in the same table because Percentage values are cumulative values based on a specific order (in first table by "Invoiced value" and in the second one by "Margin Value"

I can't calculate the percentage before loading values because all the values have to be dynamically calculated based on current filters.

attached you can find the source qvw file with all the data loaded

Any Ideas ?

Thank you

Re: ABC Cross analysis

Tue, 18 Feb 2014 15:12:10 GMT

How do you compute %invoice, %Margin

with words, an equation ...

Fabrice

Re: ABC Cross analysis

Anonymous — Tue, 18 Feb 2014 15:28:33 GMT

The formula is:
(rangesum(above(sum(Invoiced),0,rowno())))/sum(Total Invoiced)

In other words every row shows the actual and above Invoice values

same story for the Margin

Re: ABC Cross analysis

bbi_mba_76 — Tue, 18 Feb 2014 15:30:24 GMT

Hi,

I've not a solution but the problem is due to the above function, in fact you have two different sort by invoice/margin. In your case, sorting by invioce, the above is not correct for the margin.

Re: ABC Cross analysis

Anonymous — Tue, 18 Feb 2014 15:35:40 GMT

Yes, that's the problem.. I'm thinking if a set analysis can be a way.

Do you think could be a solution to use a set analysis (independent of current dimension) with condition Margin<= current row margin (should be a kind of a order simulated by a set analysis).