topic Re: Complete missing rows with 0 value in QlikView

Complete missing rows with 0 value

razvan_brais — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I would like to add 0 values for some ID`s that are missing in one day.

So the values that I`m loading would look something like this :

DATE	DEP_ID	VALUE
27-Feb-2018	1	10
27-Feb-2018	2	11
27-Feb-2018	3	9
27-Feb-2018	4	12
26-Feb-2018	1	2
26-Feb-2018	2	5
26-Feb-2018	3	13
26-Feb-2018	4	12
26-Feb-2018	5	20
26-Feb-2018	6	21

What I want to achieve is in this table

DATE	DEP_ID	VALUE
27-Feb-2018	1	10
27-Feb-2018	2	11
27-Feb-2018	3	9
27-Feb-2018	4	12
27-Feb-2018(added)	5(added)	0(added)
27-Feb-2018(added)	6(added)	0(added)
26-Feb-2018	1	2
26-Feb-2018	2	5
26-Feb-2018	3	13
26-Feb-2018	4	12
26-Feb-2018	5	20
26-Feb-2018	6	21

As you can see I need to add missing DEP_ID`s for a DATE with values 0.

Can you please help me?

Thank you.

Re: Complete missing rows with 0 value

YoussefBelloum — Thu, 08 Mar 2018 09:53:33 GMT

Hi,

what do you mean by missing ID ?

the ID's are always from 1 to 6 ?

Re: Complete missing rows with 0 value

razvan_brais — Thu, 08 Mar 2018 09:55:47 GMT

Yes , I need the list to be static , but in some days ,from database , are brought only 3, or 4 etc. And when there are fewer than the static list , to add missing ID`s with value 0