topic Re: Drill Down Null Group in QlikView

Drill Down Null Group

Anonymous — Thu, 15 Oct 2015 05:37:31 GMT

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.

Re: Drill Down Null Group

sujeetsingh — Thu, 15 Oct 2015 05:46:03 GMT

Uncheck supress nulls

Re: Drill Down Null Group

Anonymous — Thu, 15 Oct 2015 05:49:05 GMT

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

Re: Drill Down Null Group

nizamsha — Thu, 15 Oct 2015 05:51:18 GMT

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

Re: Drill Down Null Group

Anonymous — Thu, 15 Oct 2015 05:52:01 GMT

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.

Re: Drill Down Null Group

jonathandienst — Thu, 15 Oct 2015 05:53:29 GMT

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.

Re: Drill Down Null Group

yujiyamane — Thu, 15 Oct 2015 05:54:04 GMT

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.

Re: Drill Down Null Group

krishna20 — Thu, 15 Oct 2015 06:07:48 GMT

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 .

Re: Drill Down Null Group

Anonymous — Thu, 15 Oct 2015 06:12:46 GMT

Hi Jonathan

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

But it still not working .

Thanks

Re: Drill Down Null Group

Anonymous — Thu, 15 Oct 2015 06:14:20 GMT

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

Re: Drill Down Null Group

jonathandienst — Thu, 15 Oct 2015 06:15:59 GMT

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

I don't know - you have not shared your script.

I assume that your reloaded the document after editing the script?

I suggest that you post your qvw or a representative sample so that the problem can be investigated in a a bit more detail.

Re: Drill Down Null Group

krishna20 — Thu, 15 Oct 2015 06:16:00 GMT

Hi,

Can you please share script or sample app??

Re: Drill Down Null Group

Anonymous — Thu, 15 Oct 2015 06:21:16 GMT

Hi,

Here is my sample file

Thanks

Re: Drill Down Null Group

Anonymous — Thu, 15 Oct 2015 06:22:17 GMT

Hi, i have share my sample file.

Thanks in advance

Really appreciate your help

Re: Drill Down Null Group

nizamsha — Thu, 15 Oct 2015 06:25:05 GMT

check this !

Re: Drill Down Null Group

Anonymous — Thu, 15 Oct 2015 06:28:49 GMT

Hi,

Thanks for your idea, but unfortunately it doesnt meet my requirement. The null prod group still cant be clicked. I want the Others Group can be drilled and clicked and show Product D, and Product E

Any idea ?

Sorry for unclear statement

Thanks

Re: Drill Down Null Group

jonathandienst — Thu, 15 Oct 2015 06:36:55 GMT

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.

Re: Drill Down Null Group

nizamsha — Thu, 15 Oct 2015 06:38:15 GMT

it will work now

Directory;

DATA:

LOAD ProdName,

Qty

FROM

(ooxml, embedded labels, table is Sheet1);

left Join(DATA)

LOAD * INLINE [

ProdName, ProdGroup

A, Group1

B, Group1

C, Group2

];

NoConcatenate

LOAD *, if(len(trim(ProdGroup))>1,ProdGroup,'others')as ProGroup Resident DATA ;

DROP Table DATA;

Re: Drill Down Null Group

Anonymous — Thu, 15 Oct 2015 06:39:38 GMT

Hi Jonathan,

So it's not possible to drill down Product D and E if they dont have the product_group ?

Ok, thanks for your explanation, i thought there is a trick drill that missing value.

Thanks in advance

Re: Drill Down Null Group

Anonymous — Thu, 15 Oct 2015 06:42:32 GMT

Hi Nizam,

I dont want to give product D and E the product Group, i want to let them blank.

I think Jonathan statement is correct and it's not possible to drill the missing value.

Anyway, Thanks for your great idea and help.