Can any one help me to meet my requirement ?
I have data like this
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,
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.
You can create ad hoc report for this. Refer the attached qvw.
Also you can see step by step creating ad hoc report on-
Or else you can share your test app for more help.
All the best
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)