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: 
Anonymous
Not applicable

ABC Cross analysis

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:

2014-02-18-1555 -001.png

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

2014-02-18-1558 -001.png

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

4 Replies
Not applicable
Author

How do you compute %invoice, %Margin

with words, an equation ...

Fabrice

Anonymous
Not applicable
Author

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

bbi_mba_76
Partner - Specialist
Partner - Specialist

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.

Anonymous
Not applicable
Author

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).