Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.


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.

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
Not applicable

Re: Populate missing sum with necessary values