I have done the Pareto analysis creating the master dimension for the ABC classification, but now I would like to create a KPI that indicates, for instance, the number of clients that are 'A', or the sum of sales for the 'A' clients. So I need to use set analysis or a sum (if ...) function but I don't really know whether this is possible or not, and if it is possible I don't know how to do it...
I would really appreciate if someone in the qlik community could help me with this!
Re: How to use set analysis using a master dimension
thank you for replying so fast. Ok, I understand that I can create a table to sum up the information for all the values of the created dimension, but what I need now is to create a KPI for the 'A Stocks' and a KPI for the 'B Stocks', for example, in the example you have attached.
So I think I need to use Set analysis or something like that but I don't know how to do it.