Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
joan
Contributor
Contributor

Using expressions in a master dimension

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

Labels (1)
1 Solution

Accepted Solutions
sunny_talwar

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

View solution in original post

3 Replies
sunny_talwar

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

ajaykakkar93
Specialist III
Specialist III

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

A 5 80%

B 35 15%
in the same way.

Please mark the correct replies as Solution. Regards, ARK
Profile| GitHub|YouTube|Extension|Mashup|Qlik API|Qlik NPrinting

joan
Contributor
Contributor
Author

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