Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi -
I have a table with the data below.
Item | Category | Style | Item status | Retail price | Qty |
A | AN | Curve | Active | 100 | 1 |
B | AS | Round | InActive | 200 | 5 |
C | AD | Flat | Active | 200 | 6 |
D | AS | Round | InActive | 300 | 7 |
E | AD | Flat | Active | 400 | 8 |
F | AE | Round | Active | 600 | 22 |
If I select 'AD' from Category and 'Flat' from Style I get this (adding row_no dynamic based on different selection critieria)
Item | Category | Style | Item status | Retail price | Qty | Row no |
C | AD | Flat | Active | 200 | 6 | 1 |
E | AD | Flat | Active | 400 | 8 | 2 |
Now, my requirement is to create a pivot table like this from the above table:
A Grade | B Grade | C Grade | |
Condition (Row no) | <2 | >1 and < 4 | Others |
count(Qty) | 1 | 2 | 0 |
Any help would be much appreciated
Refer below blog
https://community.qlik.com/t5/Qlik-Design-Blog/Recipe-for-an-ABC-Analysis/ba-p/1472867