topic Re: Drill-down in QlikView

Drill-down

Thu, 10 Apr 2014 14:11:40 GMT

Hi all,

What can be the reasons of a drill-down not working?

I got one that isn't working and I was not able to find any info on this topic. So what can be the reasons of a not working drill-down? An Expression that is blocking it? Month/year a dimension?

kind regards,

Vincent

Re: Drill-down

its_anandrjs — Thu, 10 Apr 2014 14:20:01 GMT

A dimension is reason for that if your data model is built according to drill down then you are able to use that.

Eg:-

Easy example

Reason \ Country \ State \ City

if data model is like that then you are able to drill down it with lowest level.

Regards

Re: Drill-down

Thu, 10 Apr 2014 14:31:19 GMT

I got like:

Divisionname, week, year, weekday as dimensions

Then drill down = productiondriver, productioncountry, productionfleetnumber

Expression:avg(Production.DrivingGrossDurationHrs)

I can't drill down however.

Re: Drill-down

pwd — Thu, 10 Apr 2014 14:44:04 GMT

The fields need to have more than one possible value in them, after taking the current selection into account. Otherwise it will drill down to the next field in the list automatically. Other than that there are no obvious reasons for why a drill-down would not work, maybe post an example file?

Re: Drill-down

its_anandrjs — Thu, 10 Apr 2014 14:57:21 GMT

If the association among the fields that you asking about here like Divisionname, week, year, weekday and if you select Divisionname and drill to week and if week value has info about division name then it will drill otherwise not drill take a look for example.

DivisionTable:

Divisionname, DivID,TransactionDate

Div1,d1

Div2,d2

Div1,d3

MasterCalender:

week, year, weekday,TransactionDate

In master calendar TransactionDate is here and by this date DivisionTable table connected then if you make a chart with dimension

Divisionname, week, year, weekday

and Exression

avg(Production.DrivingGrossDurationHrs)

It will easily drill down to the lower level.