Solved: Drill Down Null Group - Qlik Community

Anonymous · ‎2015-10-15

Hi I have a question,

i have a pivot table with group dimension (drill down). let's say the group dimension is Product_Group.

I have some products that don't have product_group. so it returns null ( "-" symbols) in the pivot table.

When i click the null value, it can't be drilled down. Is it possible for me to drilled the null value (null product group) ?

Thanks

Really appreciate your help.

jonathandienst · ‎2015-10-15

You don't have null values, you have missing values - there is no product group for ProdName D or E.

Either add the missing ProdGroup(s) if you need to be able to drill in to see D, E; or if you do not wish to display these rows at the Prodgroup level, use the suppress nulls option on the Properties | Dimension tab.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

sujeetsingh · ‎2015-10-15

Uncheck supress nulls

Anonymous · ‎2015-10-15

Hi,

Thanks for suggestion

I have uncheck supress null and the value is already appear. But the problem is when i click the null product_group ( - ), it doesn't drilled down and stay on that place.

Do you have any idea ?

Thanks

nizamsha · ‎2015-10-15

Hi

AS i Understood u have drill down say,product and product group product group is having null values ,if u drill down from product for product shows null value for some if u want to drill down and see the next level say itemcode and change the null value as others in product group then u can able to drill down

Anonymous · ‎2015-10-15

If he is getting some null values its mean he didnt checked the supress nulls option.

If you are having null values which are nothing but your junk/garbage values which are not associated with anything.

Then how can you drill null?? I do not think logically its possible.

jonathandienst · ‎2015-10-15

You might want to use the NullAsValue option on this field. Add this line to your load script before loading the fields in the drill down group:

NullAsValue <fieldname>; // use your fieldname here.

The value will no longer be a true null -- it will act like an empty string instead and the drill down will work the way you expect.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

yujiyamane · ‎2015-10-15

I don't think it is possible. I assume you are doing to investigate why there is null value... To do that, you have to investigate your data model.

krishna20 · ‎2015-10-15

Hi,

AFAIK You cannot click on null . Then, how it can be drilled down??

As jontydkpi‌suggest if you really need to show that null's as values in the pivot. Then use Nullasvalue function .

Anonymous · ‎2015-10-15

Hi Jonathan

I have try your suggestion which put NullAsValue before load the Product_Group in load script.

But it still not working .

Thanks

Anonymous · ‎2015-10-15

Hi,

I have already put NullAsValue in my load script, but it still not working ?

Am i wrong to put the syntax, which part i need to put that syntax ?

Thanks