topic Re: Need to repeat previous cell values in Qliksense Pivot table in App Development

Need to repeat previous cell values in Qliksense Pivot table

vamshi_1241 — Sat, 16 Nov 2024 01:35:32 GMT

Hi Team,

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.

Re: Need to repeat previous cell values in Qliksense Pivot table

brunobertels — Wed, 26 Aug 2020 10:29:19 GMT

See this post :

https://community.qlik.com/t5/New-to-Qlik-Sense/Opening-Balance/td-p/1734963

And example below from Gabriel

https://www.dropbox.com/sh/v5twzlr58gvt51t/AADR9Rwib4iPb1CPnU8HJP9Ja?dl=0

You will find how to populate null values and repeat previous ones

Hope it helps

Regards

Re: Need to repeat previous cell values in Qliksense Pivot table

vamshi_1241 — Wed, 26 Aug 2020 12:57:16 GMT

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.

Re: Need to repeat previous cell values in Qliksense Pivot table

PriyankaShivhare — Wed, 26 Aug 2020 13:10:22 GMT

For Previous value- if(len(TestA)>0,TestA,peek('TestNew')) as TestNew

for Cumulative- if(peek(Dim1)=Dim1, rangesum(peek('Cumulative'),TestB ),TestB ) as Cumulative;

Re: Need to repeat previous cell values in Qliksense Pivot table

vamshi_1241 — Wed, 26 Aug 2020 13:16:38 GMT

can we have this solution from UI itself?

Re: Need to repeat previous cell values in Qliksense Pivot table

vamshi_1241 — Wed, 26 Aug 2020 13:26:51 GMT

Thanks for all your help, below expression is worked for me -

if((Test = 'A' or Test = 'D') and Sum(Amount) = 0, before(TOTAL column(1)),Alt(sum(fabs(Amount)), 0))