Drill down on null/missing dimension

Thu, 19 Dec 2013 15:10:23 GMT

I have a bar chart which shows one dimension member with a - which is where the data has not linked to the dimension table as it is missing in the dimension table. Is there a way to:

1. Change the name of this to Unknown say - you can do this in a straight table using the presenation tab.

2. drill down on the - member.

Thanks

Re: Drill down on null/missing dimension

Thu, 19 Dec 2013 15:14:23 GMT

Try using an IF statement in the LOAD statement in the script, e.g.:

LOAD

...,

if(IsNull(Dimension) OR Trim(Dimension)='', 'Unknown', Dimension) as Dimension,

...

FROM

....;

topic Re: Drill down on null/missing dimension in QlikView

Drill down on null/missing dimension

Re: Drill down on null/missing dimension