Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
psk180590
Creator III
Creator III

Generate Missing Weeks

Hello All,

I have the following requirement.

My Data table looks like below

 

IDWeekSales
42949673792018/01264,31
2018/06

90,27

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

 

IDWeekSales
42949673792018/01264,31
2018/020
2018/030
2018/040
2018/050
2018/0690,27
2018/420

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.

13 Replies
Frank_Hartmann
Master II
Master II

Maybe like attached!

hope this helps

View solution in original post

psk180590
Creator III
Creator III
Author

Perfect.

Vielen Dank!!

Frank_Hartmann
Master II
Master II

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
Creator III
Creator III
Author

Already marked your suggestion as correct