Using expressions in a master dimension

[joan]

Hi everyone,

I am quite new using qlik sense and would like to do an ABC analysis (i.e. sales per client) using qlik sense.

I basically struggle with a master dimension I am creating in order to calculate whether a client is an 'A' client, or 'B' or 'C'.

I am using this expression ('...' refers to the cumulative percentage of sales):

If(...< 0.80,'A', If( ...< 0.95,'B', 'C'))

but it is apparently a invalid dimension.

So I have also done it creating a master measure, and it works, but as it is a measure and not a dimension, I can't create a summary table to know the number of clients that are 'A' clients, for example.

ABC         Clients          % of total Sales

A               5                         80%

B               35                       15%

...

Could someone please help me with this issue?

Thank you very much in advance,

Joan

[sunny_talwar · Accepted solution]

Have you seen this thread already? Recipe for a Pareto Analysis

[ajaykakkar93]

Hi,
is your data like
ABC Clients % of total Sales

A 5 80%

B 35 15%
in the same way.

[joan]

Thank you very much!
I had seen lots of threads but not this one. And it is exactly what I needed, so thanks again 🙂