Generate Missing Weeks

[psk180590]

Hello All,

I have the following requirement.

My Data table looks like below

ID	Week	Sales
4294967379	2018/01	264,31
	2018/06	90,27

I need to generate another Table wich looks similar to the one below

ID	Week	Sales
4294967379	2018/01	264,31
	2018/02	0
	2018/03	0
	2018/04	0
	2018/05	0
	2018/06	90,27

2018/42

0

So, on upto the current Calender Week.

I have a Calender Table with all the weeks. My Raw data gives me only the Weeks that have some Sales value present. I need to Insert 0 as sales where there are actually none.

Thanks

Sai.

[Frank_Hartmann · Accepted solution]

Maybe like attached!

hope this helps

[psk180590]

Perfect.

Vielen Dank!!

[Frank_Hartmann]

if your requirement is resolved now please close this thread by marking correct and helpful answers

Qlik Community Tip: Marking Replies as Correct or Helpful

[psk180590]

Already marked your suggestion as correct