Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Null value in Dimension

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,

JK

1 Solution

Accepted Solutions
MVP
MVP

Re: Null value in Dimension

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

7 Replies
MVP
MVP

Re: Null value in Dimension

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

priyalshah9779
New Contributor III

Re: Null value in Dimension

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

Not applicable

Re: Null value in Dimension

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,

JK

Not applicable

Re: Null value in Dimension

Thank you very much Priyal...

MVP
MVP

Re: Null value in Dimension

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

Not applicable

Re: Null value in Dimension

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,

JK

Not applicable

Re: Null value in Dimension

Thank you it is working for me.

Community Browser