Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

Drill down Report

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

1 Solution

Accepted Solutions
Highlighted
Creator II
Creator II

Re: Drill down Report

11 Replies
Highlighted
Master II
Master II

Re: Drill down Report

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.

Capture.JPG

Highlighted
Specialist
Specialist

Re: Drill down Report

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

Highlighted
Creator II
Creator II

Re: Drill down Report

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

Highlighted
Specialist
Specialist

Re: Drill down Report

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

Highlighted
Creator II
Creator II

Re: Drill down Report

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

Highlighted
Specialist
Specialist

Re: Drill down Report

Please find the attached file as per your requirement.

Hope this will help you.

Thanks,

Neha

Highlighted
Creator II
Creator II

Re: Drill down Report

Highlighted
Specialist
Specialist

Re: Drill down Report

This is what you expected..correct?

Highlighted
Creator II
Creator II

Re: Drill down Report

Yes.