Discussion board where members can learn more about Qlik Sense App Development and Usage.
I have tried multiple ways to repeat the previous cell values if the current cell is null in the Qliksense pivot table but could not achieve it. Attached sample qvw. I have a Test, Date, and Amount field in the source table and here is the business requirement,
1. Test A and D have data for only a few dates so whenever these have 0's, the previous amount should be repeated into those cells but should not cumulative amount if the next date has data.
Let say - Test A has amount 100 on 1st, 200 on 5th and 500 on 9th Jan. Hence, 2nd to 4th would be 100 instead of 0 and from 5th to 8th Jan, amount should be 200 instead of cumulative 300. My current expression is not giving this result.
2. Test B be should show cumulative numbers in the report.
3. Test C will show actual values.
See this post :
And example below from Gabriel
You will find how to populate null values and repeat previous ones
Hope it helps
Thanks for your quick response but it is not because of missing data. I have gone through the qvf attached in the dropbox but that just give us cumulative data. I have to show the previous data (which is >0) until the next data comes in the next date column.