Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
tresesco
MVP
MVP

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

View solution in original post

7 Replies
tresesco
MVP
MVP

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

priyalshah9779
Contributor III
Contributor III

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
Author

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
Author

Thank you very much Priyal...

tresesco
MVP
MVP

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
Author

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
Author

Thank you it is working for me.