topic Re: Drill-down Issues in QlikView

Drill-down Issues

Thu, 16 Jan 2014 11:20:44 GMT

Hi all,

I have a graph with a drill-down list on year/quarter/month that causes some esthetic problems when setting it to year. The graph is already also sorted on year so by doing this you will get “double year” on the x-axis. It get confusing easily as it is at this point, since if set to year it will show a full column (total) for the year in question, and the other years will have zero entries (see pic). I would like it to hide these options where the value is zero - can this be done easily?

Cheers,

Re: Drill-down Issues

whiteline — Thu, 16 Jan 2014 12:21:39 GMT

Hi.

Could you upload the sample ?

You want to hide years or empty space between the bars when the Year mode is selected ?

Re: Drill-down Issues

kiranmanoharrode — Thu, 16 Jan 2014 12:24:28 GMT

Dear Nils'

I think you have included Both Drill-down Group dimension and Dimension of the 'Year'.

Remove "Year" dimension from the dimension list.

Regards

Kiran Rode

+91 8976977897

Re: Drill-down Issues

Thu, 16 Jan 2014 12:55:16 GMT

this is sadly not an option since i need it to still be able to sort on quarter and year, or month and year. its the sorting of year and year that is a problem

Re: Drill-down Issues

Thu, 16 Jan 2014 12:58:32 GMT

i will mock up a sample and upload in a minute. the problem is the year-on-year selection that happens when i set the drill-down to year. i still need year to be in there since i need it for the comparison to month and quarter, but also if i want to look at just the year.

Re: Drill-down Issues

Thu, 16 Jan 2014 13:15:39 GMT

heres a mock-up. as you can see sorting it on year will give you a "double" year view. this is what i want to get around without removing any of the dimensions.

Re: Drill-down Issues

Anonymous — Thu, 16 Jan 2014 13:31:03 GMT

Fordimension "received_year" add: GetCurrentField(Rec)<>'received_year' to Enable condtional.

Re: Drill-down Issues

whiteline — Thu, 16 Jan 2014 16:47:08 GMT

Ok.

I guess you want to keep the months (originally decision) as stacked bar, so hiding one dimension is not an option.

Instead of received_year dimension you can just use =if(GetCurrentField(Rec)<>'received_year', received_year, '').

This creates a blank dimension and months stay stacked.