Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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.