topic Re: How to show drill-down value in text box? in QlikView

How to show drill-down value in text box?

Thu, 16 Oct 2014 20:19:11 GMT

I created a drill down hierarchy used in a list box. So when I select someone in the first “level”, the list box then shows the corresponding values in the 2nd “level”. Then when I select a value in that 2^nd value list, it shows the corresponding values in the 3^rd “level”. The 3^rd level is the final level. I’m trying to create a text box that will show the selection at the lowest “level”.

For example, if I select value 1 at level 1, then select value 3 at level 2, then select value 5 at level 3, I want the text box to show value 5 at level 3. Basically, I want to show in the text box whatever value at whatever level is selected in the drill-down list box. Can this be done?

Thanks, Dan

Re: How to show drill-down value in text box?

wms_manis — Thu, 16 Oct 2014 20:27:30 GMT

Try

=GetCurrentField(drillgroupname)

Re: How to show drill-down value in text box?

Thu, 16 Oct 2014 20:30:46 GMT

Thanks for the reponse, Wade. This works, EXCEPT it's bringing back the field name,not the value of that field.

Re: How to show drill-down value in text box?

Thu, 16 Oct 2014 20:31:01 GMT

You must try into the text box something like

=if(not isnull(GetFieldSelections(Level1)),Level1,if(not isnull(GetFieldSelections(Level2)),Level2,if(not isnull(GetFieldSelections(Level3)),Level3)))

Hope it helps!

Regards!

Remember to mark as answered if this is what you looking for!

Re: How to show drill-down value in text box?

Thu, 16 Oct 2014 20:36:19 GMT

Thanks, Jonathan. I had to add some parentheses, and got the formula to be "OK", but it only returns the first level's value...when I select the lower levels, the value in the text box remains the value of the first level.

Re: How to show drill-down value in text box?

wms_manis — Thu, 16 Oct 2014 20:37:41 GMT

no problem, use this to get the value of the field. Only one field can be selected however.

=$(=only(GetCurrentField(drillgroup)))

Re: How to show drill-down value in text box?

Thu, 16 Oct 2014 20:40:45 GMT

reorder the fields, start from Level3

=if(not isnull(GetFieldSelections(Level3)),Level3,if(not isnull(GetFieldSelections(Level2)),Level2,if(not isnull(GetFieldSelections(Level1)),Level1)))

Sorry about this mistake!

Hope it helps!

Regadss

Re: How to show drill-down value in text box?

Thu, 16 Oct 2014 20:46:39 GMT

Thanks, Wade. This didn't work for me, either. Fortunately, Jonathan's solution worked, so it appears I'm good for now.

Re: How to show drill-down value in text box?

Thu, 16 Oct 2014 20:47:41 GMT

Thanks, Jonathan...it seems to work great.