Skip to main content
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

How to get item carried away from previous day?

Hi, I have a pivot table. In Rows, i have given priority field (Values - major, minor,critical) and in columns, status field(values - open, close, inprogress) and in measure, i have given count(distinct items) . Here, it will show the count of items open in major, minor and count that got closed in major minor and critical. here my requirement is : In Day 1 - i will be getting 20 items . completed-5 pending - 15, In Day 2 - added EXTRA 20 items . completed 5, pending 15 (in pending, it should calculate pending of day1 also . so pending is 30), in day 3 - It should calculate pending of day1 day2 and day3.  I tried to use peek() inside measure but it is not working there.

Please help me with measure what should be written. Thanks in advance!

Labels (2)
0 Replies