How to get this below output in qlik

[Naps_230]

Hi,

i have one data set, need to desire output , which marked in yellow color.

i have attached the excel file. how to do in qlik.

[justISO]

Hi, by what logic do you selected lines 'marked in yellow'? Do you need ONLY rows marked in yellow color or full OUTPUT table, because why your input table bigger than output table? A lot question to understand your actual need.

[Naps_230]

Hi .

Yes,I need entire output table.need both

Just for reference i marked yellow color in out put file,those are not available in input file.

[justISO]

Ok. So how you 'generate' these yellow rows? what logic behind them? If some 'prodcode' not exist in specific month you take vol and price from first existing one?

[Naps_230]

Hi,

For reference i create manually yellow part.

It should take volume,price and deal from previous record,but prodcode shoud change according ly.

Please observe all 1/1/2020 record value,then will be understand