Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Woohoo! Qlik Community has won “Best in Class Community” in the 2024
Khoros Kudos awards!
Hello everyone,
I am new here and i began training on QlikView. I had some issues that i want you if you do not mind to help me.
I want to implement Pareto method in a chart on QlikView and for each product which class (A, B or C) it belongs to so i have to do these following steps:
- Classify the products volume in descending order ( from the highest to the smallest).
- Calculate the percentage of each product volume comparing to the total volume of all products.
- Calculate the cumaltive percentage of each product beginning with the first product ( the product that it has the highest volume) (the cumulative percentage will be cremented).
- Plot Pareto line.
- Identifiy for each product which class it belongs to:
The products that constitute 80% of the total volume will be affected to the class A (cumulative percentage between 0% and 80%).
After that, the products that make us reach 95% of the total volume will be affected to the class B ( they correspond to cumulative percentage values between 80% and 95%)
The rest of products will be affected to the class C.
I will show you now the chart that i created in the figure below.
The second column represent the products and the third column represent the products volumes.
The forth column "CUMUL PERCENTAGE" is the column where we are going to calculate the cumulative percentage of product volumes.
I am not familiar with QlikView expression functions that's why i cannot calculate the cumulative but i know how mathematically:
after sorting volumes ( the first step that i already do it), we take the first product "SPH" cumul percentage of this product is its volume devided by the total volume of all products, we put the result of this division in the first empty cell in column 4 . Then, again, in column 4 , the second cell, its value will be the volume of the second product VX_PHYSIO_3 divided by the total volume, and the result will be added to the first result ( the value above).
But i cannot make this in QlikView.
I want to know also how to show only the product of class A and then products of class B,etc.
I hope that my issue is clear and it is very nice if you can help me.
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
The second issue: how to get rid of undesirable values.
I tried here to calculate the forecast accuracy of products expressing in percentage. My aim is to deal with the products that have a bad accuracy ( less than 80%) so i want to let in my chart only the product that they have a bad accuracy and do not show products with accuracy upper than 80%.
How can I do, please?
THANK YOU.
Hello,
thank you for answering. I took it a look and i cannot do the second step, i mean the sort by expression beacause i cannot choose it. This is what i have. Any help please? Another issue is that i did not know when i put the expression to color the Pareto class. Thank you for helping.
A
Hello,
thank you for answering. I took it a look and i cannot do the second step, i mean the sort by expression beacause i cannot choose it. This is what i have. Any help please? Another issue is that i did not know when i put the expression to color the Pareto class. Thank you for helping.
Hello,
thank you for answering. I took it a look and i cannot do the second step, i mean the sort by expression beacause i cannot choose it. This is what i have. Any help please? Another issue is that i did not know when i put the expression to color the Pareto class. Thank you for helping.
Hello Marcus,
thank you for responding. If i understand you, i think it is a part of a dimension group. So can you explain to me how to enable the latest option?
Thank you,
Alâa Eddine
Hello,
i did it but i had an issue in Accumulate sales. The sales are not accumulated. Do you know why please?
