topic Re: Drill down issue in QlikView

Drill down issue

rajeshvaswani77 — Tue, 09 Oct 2012 09:19:05 GMT

Hi All,

This is something every simple that I am facing.

Scenario

I have an speeadsheet that has rows for division, Policy Number, Indicator1, Indicator2.

There are many divisions and they have policy numbers under them, indicator1 is a fictitious flag that can be Y or N and in teh same way Indicator2 is again a Y or N flag.

Bar chart showing Divisions on the X axis and the percentage of records where indicator1 is N and indicator2 is N to be shown on the Y axis. This is done usign an expresion and works fine.

The issue is that when i select the bar from the chart, I want to see all teh records that have N for that bar. At the moment only the Division is filtered. I tried setting up the indicator1 and indicator2 as dimensions too, resulted in stacked charts.

Can someoen help on this. Final outcome needed is when bar for indicator1 is clicked, I want to see all the records for that division and having indicator1 as N to get filtered and shown the table object below.

Attaching the example along with this post.

thanks,

Rajesh Vaswani

Re: Drill down issue

rajeshvaswani77 — Wed, 10 Oct 2012 07:59:41 GMT

Hi All,

Any of your inputs on this?

thanks,

Rajesh Vaswani

Re: Drill down issue

Wed, 10 Oct 2012 08:48:08 GMT

Hi,

Maybe you could try this one.

Regards,

Janzen

Re: Drill down issue

rajeshvaswani77 — Wed, 10 Oct 2012 10:35:54 GMT

Hi Janzen,

Have you created Group 1?

thanks,

Rajesh Vaswani

Re: Drill down issue

Thu, 11 Oct 2012 01:35:49 GMT

Hi,

Yes, alternate state Group 1. Did it work?

Regards,

Janzen

Re: Drill down issue

rajeshvaswani77 — Thu, 11 Oct 2012 08:42:34 GMT

Hi Janzen,

What should Group1 and Group2 contain?

thanks,

Rajesh Vaswani

Re: Drill down issue

Thu, 11 Oct 2012 09:24:54 GMT

Hi,

Group 1 and Group 2 are alternate states. It is created under document properties, general tab.

You can search for the meaning oof alternate states.

Regards,

Janzen

Re: Drill down issue

rajeshvaswani77 — Thu, 11 Oct 2012 09:32:38 GMT

Hi Janzen,

I am on QlikView 10 SR4. No alternate states here. Any workaround to acheive the same here?

thanks,

Rajesh Vaswani

Re: Drill down issue

Thu, 11 Oct 2012 09:39:05 GMT

Hi,

I'm sorry I thought you are using QV11.

Can you upgrade to QV11?

Regards,

Janzen

Re: Drill down issue

rajeshvaswani77 — Thu, 11 Oct 2012 09:42:06 GMT

Hi Janzen,

No all our projects are on QlikView 10. If there is an alternate way to achieve this in QV10 then it would be great.

Thanks,

Rajesh Vaswani