topic Drilldown Window on selection Expression in QlikView

Drilldown Window on selection Expression

Wed, 03 Feb 2016 08:31:34 GMT

Dear QV Experts,

A pie chart with three dimensions, based on the date schedules categorizing into Green, Amber, Red.

Now need to drilldown should show three columns in Straight Table.

Can you please guide me on this.

The test qvw & input file enclosed for your reference.

Thanks,

Re: Drilldown Window on selection Expression

Chanty4u — Wed, 03 Feb 2016 08:37:13 GMT

may b

Re: Drilldown Window on selection Expression

Anonymous — Wed, 03 Feb 2016 08:43:00 GMT

Hi,

PFA

Hope it helps!!

Re: Drilldown Window on selection Expression

Wed, 03 Feb 2016 08:54:22 GMT

Sorry I added the updated qvw.

Here the dimension is Acknowledgement & Expression is Count(Newserv Id)

Green - 74

Amber - 27

Red - 12

Now selecting Red, only 12 rows should display in Straight Table

Selecting Amber in Pie Chart, only 27 rows should display in Straight Table.

Selecting Green in Pie Chart, only 74 rows should display in Straight Table.

Please suggest me on this.

Thanks,

Sasi

Re: Drilldown Window on selection Expression

Wed, 03 Feb 2016 09:03:16 GMT

Hi AnilKumar - Thanks & This is not the expected one.

Here the dimension is Acknowledgement & Expression is Count(Newserv Id)

Green - 74

Amber - 27

Red - 12

Now selecting Red, only 12 rows should display in Straight Table

Selecting Amber in Pie Chart, only 27 rows should display in Straight Table.

Selecting Green in Pie Chart, only 74 rows should display in Straight Table.

Re: Drilldown Window on selection Expression

Wed, 03 Feb 2016 09:03:53 GMT

Hi Suresh,

Thanks. But the expected one below,

The dimension is Acknowledgement & Expression is Count(Newserv Id)

Green - 74

Amber - 27

Red - 12

Now selecting Red, only 12 rows should display in Straight Table

Selecting Amber in Pie Chart, only 27 rows should display in Straight Table.

Selecting Green in Pie Chart, only 74 rows should display in Straight Table.

Re: Drilldown Window on selection Expression

sunny_talwar — Wed, 03 Feb 2016 09:31:13 GMT

May be like attached:

Re: Drilldown Window on selection Expression

Wed, 03 Feb 2016 10:25:28 GMT

Thanks Sunny. Excellent.