topic Drill down Report in QlikView

Drill down Report

balanandam — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

Can any one help me to meet my requirement ?

I have data like this

Transaction:

Date, transactionid

11/05/2017, 1234

11/05/2017, 1235

11/05/2017, 1236

12/05/2017, 1237

12/05/2017, 1238

12/05/2017, 1239

12/05/2017, 1240

Activity:

ActivityID, transactionID

1,1234

2,1234

3,1235

4,1236

5,1237

6,1237

7,1239

8,1239

9,1240

Initially, Report has transaction data in tabular format and when I click on transactionid, that should open the detail report of particular transactionid, i.e, all Activity report(switches to detail report), in the kind of way Master and Child style, finally, Activity report should have Close button, that drives me back to the Master Report. Hope, you got what I'm trying to say...

Appreciates, if provides the sample qvw.

Thanks in advacne,

Balanandam

Re: Drill down Report

devarasu07 — Tue, 05 Dec 2017 09:23:49 GMT

Yes it can be done.

try to use cycle / drill down group method in qlikview

Go to Setting - >Document Properties ->Groups --> New -- > Select the DrillDown option and

add the dimension transactionid, Date, etc

And add the DrillDownName in dimension using chart.

Re: Drill down Report

neha_shirsath — Tue, 05 Dec 2017 10:44:58 GMT

You can create another chart with all details fields you need to show and add the show/hide condition in Layout tab.

Re: Drill down Report

balanandam — Tue, 05 Dec 2017 11:04:22 GMT

Yes,Neha. This way I need. can you give me the steps, since I'm very new to Qlikview.

Re: Drill down Report

neha_shirsath — Tue, 05 Dec 2017 11:11:40 GMT

You can create ad hoc report for this. Refer the attached qvw.

Also you can see step by step creating ad hoc report on-

Customizable Straight Table

Or else you can share your test app for more help.

All the best

Re: Drill down Report

balanandam — Wed, 06 Dec 2017 04:42:23 GMT

Neha, attached sample report. it will have both Transaction & Activity tables. when I click on any transactionid, that should be open the detail report (i.e, switch to Activity Report) and finally when close the detail report (Probably click on Button) I should be on on transaction report(i.e, transaction tab)

Regards,

Balanandam

Re: Drill down Report

neha_shirsath — Wed, 06 Dec 2017 05:22:10 GMT

Please find the attached file as per your requirement.

Hope this will help you.

Thanks,

Neha

Re: Drill down Report

balanandam — Wed, 06 Dec 2017 05:55:08 GMT

Many Thanks!

Re: Drill down Report

neha_shirsath — Wed, 06 Dec 2017 06:02:13 GMT

This is what you expected..correct?

Re: Drill down Report

balanandam — Wed, 06 Dec 2017 06:07:08 GMT

Yes.

Re: Drill down Report

neha_shirsath — Wed, 06 Dec 2017 06:11:57 GMT

Then mark it to helpful/correct.

Re: Drill down Report

balanandam — Tue, 16 Jan 2018 05:41:18 GMT

Hi Neha,

I have one problem with your solution, I have another sheet with same TransactionId even I clicked over there it will redirects to the Activity sheet. But it is not expectation, Activity sheet should be opened when I click on transaction Id on Transaction sheet only. Attaching the scenario.

Hope you understand this!

Br, Balanandam