topic Re: Re: Re: Drill through Reporting requirement in QlikView

Drill through Reporting requirement

Tue, 25 Nov 2014 09:32:21 GMT

Hi,

I am new to Qlickview and I have drill through reporting requirement

I need to implement the drill through report (From the summery report to the detailed report)

Eg We have summery report with following aggregated info

Region Sales

India 10000

Chaina 40000

Malaysia 5000

And current selection in the summery reports is Year = 2014

When we click on the Sale summery of particular region then the associated detail report should launch

Region Product price quantity

India Prod 1 10 2

India Prod 2 5 4

India Prod 1 7 4 etc

Please provide the step by step process to implement the same in word document (I am using the Qlickview personal server)

Re: Drill through Reporting requirement

Tue, 25 Nov 2014 10:19:04 GMT

Can you send me some sample data?

Re: Re: Drill through Reporting requirement

Tue, 25 Nov 2014 12:38:18 GMT

Hi,

Thanks for the help .I have attached the sample data for your reference

PolicyInfo TAB :- Row Data for the report

Summery TAB : - Summery by Region

Detailed TAB :- Expected detailed report when we click on particular region

Re: Re: Re: Drill through Reporting requirement

Tue, 25 Nov 2014 13:25:44 GMT

Try this

I use sum(ANP) as the expression and put all the demensions in, I then do a conditional show on all the demensions but Region of count(distinct Region)=1 (see attached)

Re: Re: Re: Drill through Reporting requirement

Tue, 25 Nov 2014 14:06:22 GMT

Thanks for your quick response. It would be great if you can provide me screen capture (Screen shots) for the steps which you followed in test1.qvw (since I am using Qlick View personal edition and I can’t open file from my PC)

Re: Re: Re: Re: Drill through Reporting requirement

Tue, 25 Nov 2014 14:15:00 GMT

Create a straight table with all your demensions except ANP in it (as per your detail example):

On every Demension but the region tick the Enable condition and enter this

count(distinct [Region Code]) = 1

Expression as below:

This will create a table that when no region is selected will show you sales by region but once you select a region it will epand to show you each demension and hence the detail level.

Re: Re: Re: Drill through Reporting requirement

Tue, 25 Nov 2014 16:41:48 GMT

Did this work ok for you?

Re: Re: Re: Drill through Reporting requirement

Wed, 26 Nov 2014 02:52:24 GMT

Thanks for your help. I have tried the steps and Its enabled me for the drill down option ie. when we click on the region all other attributes displayed .I would require kind of navigation to the new qvw file with all row level information (Since the summery report layout will have other summery information other than the region & ANP so it can’t accommodate entire field level info in the same report)

Re: Re: Re: Drill through Reporting requirement

Wed, 26 Nov 2014 03:01:02 GMT

Is there any option to launch new report from summery with current field selection

Re: Re: Re: Re: Drill through Reporting requirement

Wed, 26 Nov 2014 08:42:03 GMT

yes you create 2 charts with a conditional show option with the same criteria as I used for the demensions

Re: Re: Re: Re: Drill through Reporting requirement

Wed, 26 Nov 2014 08:44:14 GMT

You could use the function getselectedcount(Region) as well.

Re: Re: Re: Re: Re: Drill through Reporting requirement

Wed, 26 Nov 2014 09:39:28 GMT

Thank you very much.I have created two sheets in single file ,one is for summery and other is for detailed records.Now its working.Attached the screen shots