topic Re: drill down group expressions in QlikView

drill down group expressions

alec1982 — Wed, 14 Oct 2015 17:18:18 GMT

hi all,

I am trying to build a dynamic drill down group of 10 levels (Dimensions).. I want to show different expression based on the dimensions the user is on. for example if the user on dimension 1 the expression will be count items, if the user on dimensions 2 then the expression is sum amount then if if the user drill down to dimension 3 the expression will be sum of shipping amount..

the above is doable by using GetCurrentField(group_name)..

One thing that I am trying to do is to ignore a dimensions if there is no value for it.. for example, if the user is on dimension 1 and then within the data dimension 2 has nothing then when the user drill down he/she will be pushed to dimension 3.. any idea how to make that?

Re: drill down group expressions

JonnyPoole — Wed, 14 Oct 2015 17:25:59 GMT

i think thats the default even when there is just 1 value in the intermediate dimension. Is that not the behavior you are seeing when you drill down from dimension1 ? (and there is zero or just 1 value underneath)

Re: drill down group expressions

alec1982 — Wed, 14 Oct 2015 22:05:16 GMT

for the major part yes.. but when it reach the last available level such as Level 3 then I click on that bar, it shows no data to display while I want it to stay on the last available level..