ABC analisys with macro. There is an idea need help.
So, after several months of searching until I conclude that in a flexible and functional in Qlik ABC analysis not possible. Option with a rank no good because having several dimensions Rank astray, my questions as it answers to settle there.
Option with the amount of non-productive.
It remains for me the last option. Macro.
Since I do not understand macros, I ask for help from the community.
Mathematical meaning set out in the Excel file, who understands macros think will understand this. In short - a few iterations, we are looking for the amount of sales between which and a maximum amount of a commodity A - ie, 80% of sales. Similarly, B and C for the balance.
The macro should analyze the amount of sales and output variables, such as two pieces. A price comparison for A and one for B.
That's the idea. First you need to become familiar with the file that you understand the math.
Any idea how to do it? Honestly I have no more ...
