Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

andreyfcdk91
Not applicable

Populate missing sum with necessary values

Good day!

I have qvd file with fields:

Revenue with VAT price

Revenue w/o VAT price

Net revenue price

Net net revenue price


These fields agregated by PricesKey and YearMonth.

For some YearMonth values (Revenue with VAT price,Revenue w/o VAT price,Net revenue price,Net net revenue price)  is null.

In these cases i need get values from nearest previous YearMonths.


Many thanks for help.


1 Reply
morganaaron
Not applicable

Re: Populate missing sum with necessary values