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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
AC7
Contributor
Contributor

Dynamic grouping(count) based on Row no on different selection (Dimension) in Qliksense 2018

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

Labels (2)
1 Reply
vinieme12
Champion III
Champion III

Refer below blog 

https://community.qlik.com/t5/Qlik-Design-Blog/Recipe-for-an-ABC-Analysis/ba-p/1472867

 

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.