Drillthrough from a table

[#1]

Hi

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

[alexandros17]

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

[#3]

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.

[stevedark]

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

[#5]

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

[stevedark]

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.

[#7]

Thanks Steve for your help on this