topic Re: Drill down group level be skiped in bar chart in QlikView

Drill down group level be skiped in bar chart

Fri, 15 Jul 2011 09:55:42 GMT

I have a chart with a drill down group as dimension

Cat ---> Product ID

When i come to the bar chart , the chart skiped the Cat level and directly display the level of ProductID

I want to have a option to drill from the Cat level ,anyone can help with that or any workaround solution ?

Here is the example

Drill down group level be skiped in bar chart

kaushiknsolanki — Fri, 15 Jul 2011 10:04:00 GMT

Hi,

I dont know is this the pefect reason or not, but when you include one more value in Cat Field, say for example you have something like this

LOAD * INLINE [

ProductId, Amt, Cat

a, 10, Group

b, 10, Group

c, 10, Group

d, 10, Group

e, 20, Group2

];

The levels are shown as they are descirbed in the group.

Regards,

Kaushik Solanki

Re: Drill down group level be skiped in bar chart

IAMDV — Fri, 15 Jul 2011 10:13:35 GMT

Hi,

Kaushik is right. You can need to include some psuedo value in your Cat Field and you can restrict the same in your expression. Then you will only see Group and not Group2.

SUM({$<Cat -= {"Group2"}>}Amt)

I am attaching a quick example.

Hope this helps!

Cheers - DV

Re: Drill down group level be skiped in bar chart

IAMDV — Fri, 15 Jul 2011 10:15:11 GMT

Sorry - I haven't uploaded the correct QV document. Here is what you need...

Cheers - DV

Re: Drill down group level be skiped in bar chart

Mon, 18 Jul 2011 08:43:57 GMT

Thanks Brother. Information is helpful.

However ,my actual problem is more complicated

Because my fact and dimension table are seperated

I have created another example to simulate the case.

The Fact table may linked to different dimension. In my example is just product and customer

If i add the psuedo value ,i need to add to both fact and dimension in order to bring back my Group level in drill down .

And it need to add on every possible selection of the dashboard as well

e.g. In my example i need to add

e,,C2

e,,C3

e,,C1

My working dashbard has about 10 dimensions ,if i follow the solution ,it will create huge amount of dummy data .It reduct the performanance

and i need to rewrite every expression to filter out the dummy data

Is there any workaround ?

Re: Drill down group level be skiped in bar chart

rwunderlich — Tue, 19 Jul 2011 06:22:50 GMT

The way I handle this problem is to add a null() to each dimension that may have only one value. The nulls will be filtered out by default but will create the desired group behavior. See attached.

-Rob

http://robwunderlich.com

Re: Drill down group level be skiped in bar chart

IAMDV — Tue, 19 Jul 2011 11:57:34 GMT

Rob - This is clever solution. And I think is the best workaround for this issue.

Many thanks again!

Cheers - DV