Drilldown Window on selection Expression

[#1]

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,

[Chanty4u]

may b

[Anonymous]

Hi,

PFA

Hope it helps!!

[#4]

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

[#5]

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.

[#6]

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.

[sunny_talwar · Accepted solution]

May be like attached:

[#8]

Thanks Sunny. Excellent.