Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Click on chart values to open a detail sheet

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.

7 Replies
nagaiank
Valued Contributor III

Re: Click on chart values to open a detail sheet

Yes. A sample application is attached.

Not applicable

Re: Click on chart values to open a detail sheet

Hai,

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

Regards,

Senthil

Not applicable

Re: Click on chart values to open a detail sheet

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.

Not applicable

Re: Click on chart values to open a detail sheet

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
Valued Contributor III

Re: Click on chart values to open a detail sheet

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

Not applicable

Re: Click on chart values to open a detail sheet

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 ?

Not applicable

Re: Click on chart values to open a detail sheet

Hi Krishna,

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

Kindly advice.

Thanks

Community Browser