Drill Down Null Group

[Anonymous]

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]

>>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.

[krishna20]

Hi,

Can you please share script or sample app??

[Anonymous]

Hi,

Here is my sample file

Thanks

[Anonymous]

Hi, i have share my sample file.

Thanks in advance

Really appreciate your help

[nizamsha]

check this !

[Anonymous]

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

[jonathandienst · Accepted solution]

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.

[nizamsha]

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;

[Anonymous]

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

[Anonymous]

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.