Pivot Previous Column value

Karthick30 — Thu, 17 Feb 2022 12:20:50 GMT

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

Re: Pivot Previous Column value

SBDataspark — Thu, 24 Feb 2022 14:49:30 GMT

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

topic Pivot Previous Column value in App Development

Pivot Previous Column value

Re: Pivot Previous Column value