Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
A7R3
Contributor III
Contributor III

Show/Sort certain rows in pivot table depending on measures

Hi,

I am using the pivot table to display the inventory qty over several date, and calculate the increases/decreases using the measure in the table.

 202106292021062920210630202106302021070120210701
 Sum(QtyTotalStock)Sum(QtyTotalStock)
/
BEFORE(Sum(QtyTotalStock))
Sum(QtyTotalStock)Sum(QtyTotalStock)
/
BEFORE(Sum(QtyTotalStock))
Sum(QtyTotalStock)Sum(QtyTotalStock)
/
BEFORE(Sum(QtyTotalStock))
A1118.32-118.32100%57.3648%
A24400-4400100%00%
A34000-4000100%200050%
A42000-2000100%00%
A52-2100%150%
A613-431%125%
A73-133%00%

 

I highlighted the part that has significant reduction over the previous day. So far so good.

A7R3_0-1625135246659.png

The problem is that there are thousands of rows in this table, and it is difficult to spot those parts with signification reduction.

What is the best way to highlight theses parts? It can be through sorting by measure (in ascending order) or show only the part number if the reduction % is lower than 50%).  

Any other advise/suggestion is welcome.

 

 

 

 

Labels (2)
1 Reply
A7R3
Contributor III
Contributor III
Author

Here is the raw data. Appreciate if someone can help. Thank you in advance.

DateMaterialQtyTotalStock
20210629A1118.32
20210630A1118.32
20210701A157.36
20210629A24400
20210630A24400
20210701A20
20210629A34000
20210630A34000
20210701A32000
20210629A42000
20210630A42000
20210701A40
20210629A52
20210630A52
20210701A51
20210629A613
20210630A64
20210701A61
20210629A73
20210630A71
20210701A70
20210629A8193
20210630A8191
20210701A8191
20210629A9106
20210630A9106
20210701A9106