topic Re: Drill down in QlikView

Drill down

Mon, 28 Jan 2013 14:48:16 GMT

Hi,

I'm busy with a pivot table, where I can drill down to the lowest level.

I already made something where the user can drill down by making a new group.

But when the user drills down on an item, the upper layer dissapears.

I just want a '+' symbol, that every level stays visible when you drill down.

Does somebody knows a solution for my problem?

Regards,

Tim

Re: Drill down

SunilChauhan — Mon, 28 Jan 2013 14:52:19 GMT

i am not getting you correctly but

i guess chart->properties->uncheck fully expanded option

hope this helps

Re: Drill down

Mon, 28 Jan 2013 15:10:04 GMT

it's not working..

Re: Drill down

khadeer — Tue, 29 Jan 2013 04:54:08 GMT

I think u taken the dimension is group(cyclic or drill down), if u r taking group u can't get that option.

If u r taking 4(assume) dimensions, u can drill down that what u say, ......

else send me some sample data in Inline table. I will try.

Re: Drill down

Tue, 29 Jan 2013 12:33:32 GMT

Here you can see an easy pivot table with my problem

When you drills down on Level1 => level2 is shown, but Level1 is gone

Regards

Re: Drill down

Gysbert_Wassenaar — Tue, 29 Jan 2013 13:45:06 GMT

That's not possible. What you could try is using more charts, one for each level, and show the lower level charts only if one item is selected in the level above. You can use expressions like if(getselectedcount(FieldX)=1,1,0) for the conditional display (under Show on the Layout tab of the charts properties screen). Change FieldX to the field name of the field you drill down in.