topic Re: Null value in Dimension in QlikView

Null value in Dimension

Wed, 07 Jan 2015 06:46:56 GMT

Hi all,

Here I am creating a bar chart ,which got a drill down dimension ,in this hierarchy middle one got unspecified values ,description given below

zone A

Zone B

Div1

Div2

Div3

Div4

Div5

-----

Sub_Div1

Sub_Div2

Sub_Div3

-------------

how to handle this issue...PFA

Thanks,

Re: Null value in Dimension

tresB — Wed, 07 Jan 2015 07:10:30 GMT

Try, enabling 'Supress When Value is Null' in the dimension tab.

Re: Null value in Dimension

priyalshah9779 — Wed, 07 Jan 2015 07:20:32 GMT

Hi Janaki

Two ways to handle it

1) You can check "Suppress When Value is Null".

2) Enter "Unknown" in Null records.

See the attached example

Thanks

Priyal

Re: Null value in Dimension

Wed, 07 Jan 2015 07:35:39 GMT

Hi ,

I tried it ,but no use, problem here with data. Data as follows

Zone Division Sub-Division Arrears

1 Div1 SD1 10

1 Div1 SD2 20

2 Div4 SD3 30

1 SD3 10

3 Div5 40

Those null values i have shown in the above data causes problem,here Zone,Division,Sub-Division are my dimensions.

can you help me on this issue.

Thanks,

Re: Null value in Dimension

Wed, 07 Jan 2015 07:48:33 GMT

Thank you very much Priyal...

Re: Null value in Dimension

tresB — Wed, 07 Jan 2015 07:51:26 GMT

That is actually not NULL, rather a space. Try to use calculated dimension in group like:

=If(Len(Trim(Division))>0,Division) // similarly for sub-division as well

PFA

Re: Null value in Dimension

Wed, 07 Jan 2015 08:15:10 GMT

Can you explain that 2nd point Enter "Unknown" in Null records.do you want me change in entire actual data?,I didn't get that.

thanks,

Re: Null value in Dimension

Wed, 07 Jan 2015 08:33:29 GMT

Thank you it is working for me.