Pivot Previous Column value

[Karthick30]

Hi,

I added Material as Pivot Dimension(Row) and Month as Dimension(Column) and Measure as Sum(sales)

but I am getting certain zeros(0.00) and null's for few values.

Requirement is if March value is 0 means , then i need to show feb value.. likewise whichever month is 0 or null , i need to show that with previous month.

Tried with Before function.. ( if(isnull(sum(sales),before(sum(sales)), sum(sales))). but this also giving empty values.

Any help on this

[SBDataspark]

Hi Karthick30,

In Qlik Sense you need to create "dummy" lines for missing dates in a dataset.
With the attached QVD you get an insight in how you can create these missing dates.

You can also have a look at the following blog post:
Generating Missing Data In QlikView - Qlik Community - 1491394

Kind regards,

Sebb