Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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