Drill down Report

[balanandam]

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

[devarasu07]

HI

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.

[neha_shirsath]

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

[balanandam]

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

[neha_shirsath]

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

[balanandam]

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

[neha_shirsath]

Please find the attached file as per your requirement.

Hope this will help you.

Thanks,

Neha

[balanandam · Accepted solution]

Many Thanks!

[neha_shirsath]

This is what you expected..correct?

[balanandam]

Yes.