Discussion Board for collaboration on QlikView Layout & Visualizations.
Here I am creating a bar chart ,which got a drill down dimension ,in this hierarchy middle one got unspecified values ,description given below
how to handle this issue...PFA
Go to Solution.
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
Try, enabling 'Supress When Value is Null' in the dimension tab.
Two ways to handle it
1) You can check "Suppress When Value is Null".
2) Enter "Unknown" in Null records.
See the attached example
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.
Thank you very much Priyal...
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.
Thank you it is working for me.