topic Re: RNAM - Topline is shown in my drilldown structure in QlikView

RNAM - Topline is shown in my drilldown structure

Mon, 27 Jan 2014 20:29:01 GMT

Hi Everyone,

I am creating a drill down group with RNAM being the top drill and then company follwed organizations and so on.

I notice RNAM is not shown in my chart, it displays starting with company even though RNAM is the first level in my drill down group

any inputs on why RNAM is not shown and any suggestions on how to get RNAM shown in the drill down chart,

appreciate your help on this

Re: RNAM - Topline is shown in my drilldown structure

Gysbert_Wassenaar — Mon, 27 Jan 2014 20:31:45 GMT

If the RNAM dimension contains only one value then the values of the next level down will be shown instead.

Re: RNAM - Topline is shown in my drilldown structure

phaneendra_kunc — Mon, 27 Jan 2014 20:33:11 GMT

Does you RNAM has only one value (Data)?

Re: RNAM - Topline is shown in my drilldown structure

Mon, 27 Jan 2014 20:33:47 GMT

Thanks Gysbert, it makes sense

Re: RNAM - Topline is shown in my drilldown structure

Mon, 27 Jan 2014 20:35:11 GMT

yes, it has only RNAM in the entire data

Re: RNAM - Topline is shown in my drilldown structure

Mon, 27 Jan 2014 20:51:11 GMT

I have actually tried changing few values in the top line then it seem to show.

But my question is , my previous teammates already did the same chart for a different division , in that RNAM is shown even though contained only RNAM in it.

Re: RNAM - Topline is shown in my drilldown structure

phaneendra_kunc — Mon, 27 Jan 2014 20:56:05 GMT

That is the default behaviour of Drill Group.

Change it to Cycle Group and it wont skip if that column has single value...

Re: RNAM - Topline is shown in my drilldown structure

Mon, 27 Jan 2014 21:11:32 GMT

Hi Phaneendra,

That works , but when I click on RNAM it would nt let me drill down , I need pick it up from dropdown to look into the drill down, is there way out of this, ?

Re: RNAM - Topline is shown in my drilldown structure

phaneendra_kunc — Mon, 27 Jan 2014 22:43:09 GMT

There is no way...Only way is its a two step process...You have make a selection and cycle trough and select your desired dimension.

Re: RNAM - Topline is shown in my drilldown structure

Carlos_Reyes — Mon, 27 Jan 2014 23:05:01 GMT

It's not ideal and will be confusing but you can use the Enable conditions box on each field that composes the drill down group. So, you add all the fields in order as dimensions, for instance, RNAM at the top, the next field and so on...

Then you place the following expression in the Enable conditional box. You'll have to change the field name accordingly:

For RNAME or the top field:

getselectedcount( TopField )<1

For the next field

getselectedcount( TopField )=1 and getselectedcount( NextFieldName ) <1

For the third field

getselectedcount( TopField )=1 and getselectedcount ( NextFieldName ) = 1 and getselectedcount( ThirdFieldName ) <1

and so on....

The drawback with this method is that you'll need to select only one value on each field in order to show the next level...

I think that the default Drill Down or Cyclic groups are the best options... It's just a matter that the users get used to it.

Re: RNAM - Topline is shown in my drilldown structure

Tue, 28 Jan 2014 17:08:39 GMT

Thanks for your inputs