topic Re: Drill Down Group in QlikView

Drill Down Group

Tue, 02 Sep 2014 16:31:26 GMT

Dear team.

I would like your help regarding a doubt with Drill Down Option.

Let’s use the following dimensions in a Chart

- yearMonth / Drill Down Group (Brand > Region > District > Dealer)

When I have more than one brand do the drill down works perfectly and show me the amount of sales by each dimension, but if I have only one brand, this information is not showed and the drill down starts with Region.

Is it possible to force the drill down by brand even when I have only one Brand?

Thank you.

Regards.

Re: Drill Down Group

Anonymous — Tue, 02 Sep 2014 17:18:35 GMT

Try adding a dummy Brand of null(). Then you'll have 2 brands, you can set it to not display the null() and it should work as you wish.

Re: Re: Drill Down Group

Anonymous — Tue, 02 Sep 2014 17:37:43 GMT

Here is a sample qvw.

Re: Drill Down Group

Tue, 02 Sep 2014 17:43:31 GMT

Thank you Bill for your answer.

I'm not sure if I'm doing it in the right way, so let me resume: I Load the qvw with Brand1 values only.

Then i change the Drill Down group and I insert the following expression for EOM dimension:

=if (OEM = 'Brand1', OEM, Null() )

Didn't work.

Thank you for your help.

Re: Drill Down Group

Tue, 02 Sep 2014 17:44:23 GMT

Hey Bill.

Let me check your file..

thank you.

Re: Re: Drill Down Group

Anonymous — Tue, 02 Sep 2014 17:46:54 GMT

The load script I used was :

Data :

LOAD * INLINE [

Dim1, Dim2, Exp

A, Q, 1

A, W, 2

A, E, 2

A, R, 4

A, T, 5

A, Y, 6

A, X, 7

A, W, 2

A, E, 2

A, R, 4

A, T, 5

A, Y, 6

A, X, 7

];

Load

null() as Dim1 ,

null() as Dim2 ,

null() as Exp

AutoGenerate 1

;

As the fields are the same the second load with the dummy Nulls will concatenate onto the real data

Re: Drill Down Group

Tue, 02 Sep 2014 17:49:09 GMT

Thank you Bill.

Works perfectly... great job!!