topic Re: Raws for missing value in QlikView

Raws for missing value

Anonymous — Wed, 17 Feb 2016 15:42:01 GMT

Dear Community

I want to pop rows even which has no values without changing scrip. For below case I need C and D populated with empty rows

In my case

Prod:
LOAD * INLINE [
PC, Nm
A, ProdA
B, ProdB
C, ProdC
D, ProdD
E, ProdE
];

Sales:
LOAD * INLINE [
PC, Amt, SC
A, 1, S1
B, 2, S1
E, 5, S1
A, 11, S2
B, 12, S2
E, 15, S2
];

I am unable to attach QV file, I appreciate your help.

Thanks

Re: Raws for missing value

sunny_talwar — Wed, 17 Feb 2016 15:45:46 GMT

Check these two on dimension tab also:

Re: Raws for missing value

Anonymous — Wed, 17 Feb 2016 17:00:52 GMT

Hi Sunny

I also did but getting third empty unwanted column other than S1 & S2, like in your screen

Thanks

Re: Raws for missing value

Anonymous — Wed, 17 Feb 2016 18:41:19 GMT

It's resolved by adding same numbers of rows in through scripting with zero values.

Thanks