topic Click on chart values to open a detail sheet in QlikView

Click on chart values to open a detail sheet

Fri, 02 Aug 2013 14:50:44 GMT

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.

Re: Click on chart values to open a detail sheet

nagaiank — Fri, 02 Aug 2013 15:21:35 GMT

Yes. A sample application is attached.

Re: Click on chart values to open a detail sheet

Fri, 02 Aug 2013 15:31:50 GMT

Hai,

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

Regards,

Senthil

Re: Click on chart values to open a detail sheet

Mon, 05 Aug 2013 07:08:15 GMT

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.

Re: Click on chart values to open a detail sheet

Mon, 05 Aug 2013 07:08:26 GMT

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.

Re: Click on chart values to open a detail sheet

nagaiank — Mon, 05 Aug 2013 07:16:16 GMT

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

Re: Click on chart values to open a detail sheet

Mon, 05 Aug 2013 09:13:27 GMT

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 ?

Re: Click on chart values to open a detail sheet

Tue, 06 Aug 2013 06:41:58 GMT

Hi Krishna,

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

Kindly advice.

Thanks