topic Re: Drillthrough from a table in QlikView

Drillthrough from a table

Wed, 12 Mar 2014 20:26:37 GMT

I have a table which shows say a dimension, country and expression number of A which is a SUM. How can I create a drill through so that I can see the indiviudal records/rows that make up that SUM?

Thanks

Re: Drillthrough from a table

alexandros17 — Wed, 12 Mar 2014 20:34:26 GMT

At first you need 2 dimension, then you can use a pivot chart or a group of dimension.

The second dimension is mandatory because split the sum into its details

Re: Drillthrough from a table

Wed, 12 Mar 2014 20:35:32 GMT

Hi,

You can create a drilldown group and put all the dimensions in it that you wan to drill through.

Right click chart> Dimensions > in the bottom left > Edit Groups

You can also use a pivot table as mentioned above.

Re: Drillthrough from a table

stevedark — Wed, 12 Mar 2014 20:40:03 GMT

Hi Bhavin,

Everything in QlikView kind of drills in this way. You can make a selection on any field and all other objects flex to show what is related.

If you create a chart of type Straight Table with a single dimension and a sum you will only get one row per that dimension. Clicking one of those dimensions (or values) will select that dimension.

If you also have another Straight Table with the same sub but with more dimensions, perhaps including Transaction ID, you will get rows with more granularity. If one of the dimensions is a Unique ID then you will see all dimensions.

You can use Calculation Conditions and Show Conditions to only show the detail when a single value is selected in another dimension - creating a drill.

You can be more flexible than a straight drill through - as that requires a pre-defined path. What I tend to do is have the detail table show when there are fewer than a set number of possible rows. This way it wouldn't matter if you selected a day or an office - if that selection brought you under the set number of source rows then the details will show.

Once you get the way of how QlikView ticks these things become second nature.

Hope that helps.

Steve

Re: Drillthrough from a table

Wed, 12 Mar 2014 21:16:37 GMT

Hi Steve

Thanks for getting back.

So are you saying to have a another table for the detail? If so how would this be made available when the user wants to say know the details that made up the SUM?

Cheers

Re: Drillthrough from a table

stevedark — Wed, 12 Mar 2014 23:22:03 GMT

Hi there, yes, having two charts with different dimensions is simpler than having one chart and adding and removing dimensions.

This example shows how to do the show and hide:

QlikView App: Show and Hide Windows Dynamically

You could show both tables at the same time if space allows, one with aggregated data and the other with the detail with a scroll bar. The detailed one would then have fewer rows as you made selections in the upper table, or anywhere else for that matter.

Re: Drillthrough from a table

Thu, 13 Mar 2014 08:59:17 GMT

Thanks Steve for your help on this