Click on chart values to open a detail sheet

[#1]

Hi,

I need to have a chart with aggregated values displayed. When one clicks on any value, it should open a new sheet with the details.

For example: say I have a chart with the data as

Product   Count(Cust)

P1                   3

P2                   14

P3                    5

P4                    7

Note: P1, P2,... are the products. and the corresponding numbers are the count of customers for each product.

Now when I click on 14, it should open a new sheet with the details of those 14 customers, their names, other details etc.

Similarly, when I click on 5 it should take me to the sheet with details of those 5 customers.

Please suggest if this is achievable in Qlikview.

Thanks in advance.

[nagaiank]

Yes. A sample application is attached.

[#3]

Hai,

I am using PE please little brief explain me. We also facing like that issue.

Regards,

Senthil

[#4]

Hi,

Thanks for your answer.

However, I need something different from this. I need a drill down kind of report, where when I click on the aggregated data, a new report/sheet should be opening with the details.

Can you please help me on this.

Thanks in advance.

[#5]

Hi,

Thanks for your answer.

However, I need something different from this. I need a drill down kind of report, where when I click on the aggregated data, a new report/sheet should be opening with the details.

Can you please help me on this.

Thanks in advance.

[nagaiank]

You may create a hierarchical group and use the group as dimension.

[#7]

Hello Krishna,

I was just looking for the same problem solution which you have provided.

But the attachement is not accessible at my end saying that its created with some other personal edition key and opening that will prevent me accessing apps created with my key.

Any suggestion on this ?

[#8]

Hi Krishna,

I need a new sheet to open ....not on the same sheet.

Kindly advice.

Thanks