topic Create Dimension with zero value if not present in QlikView

Create Dimension with zero value if not present

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have a requirement to create a Heat Map like below where one dimension having value : A,B,C and other dimension : 1,2,3 and 4.

Based on some calculation, I got the values as 2,3 and 4 but there is no value for 1 (see image 1).

So, I want to display 1 also here, with value 0 like in Image 2.

PS: On un-checking "Suppress When value is NULL", it is showing ' - ' in dim1 and dim2 both.

Pls help.

Regards,

Anjali Gupta

thomaslg_wq — Mon, 28 Nov 2016 09:07:25 GMT

You may need to play with these parameters (see screenshots) :

Mon, 28 Nov 2016 10:08:12 GMT

Hi Thomas,

Thanks for the response. But it didn't worked.

Instead I did inline load as below :

Dimension:

LOAD * INLINE [

Dimension

];

Dimension1:

LOAD

Mid(Dimension,1,1) as DIM2,

Mid(Dimension,2,1) as DIM1

Resident Dimension;

DROP Table Dimension;

And this worked for me.

Regards,

Anjali Gupta