Populate Missing Data

[qlikviewaf]

Hi,

in my script i have:

• Area
• Region
• Invoice Date

i would like to generate all missing invoice date records on the sales table for Region/Area combination.

e.g.

Sales1 - 10/09/2017 - Area1 - Region1

Sales2 - 13/09/2017 - Area1 - Region2

I expect to have generated the missing combination::

SalesGenerated1 - 10/09/2017 - Area1 - Region2

SalesGenerated2 - 13/09/2017 - Area1 - Region1

Anyone can help with this?

Thank you

[Kushal_Chawda]

It will be helpful if you can share the sample