topic Drill down requirement in QlikView

Drill down requirement

kishorj1982 — Tue, 17 Oct 2017 09:43:23 GMT

Hi all,

I am using Hierarchy Area->Country->company->Region

When ever I am navigating to company my navigation display chart caption would be

SelectedAreaName|SelectedCountryName

for Area to Region display would be

SelectedAreaName|SelectedCountryName|SelectedCo,panyName

Can you please suggest how to proceed

Re: Drill down requirement

Anil_Babu_Samineni — Tue, 17 Oct 2017 10:01:31 GMT

What if Country has 2 values for selected one which is associate to another one?

Re: Drill down requirement

mdmukramali — Tue, 17 Oct 2017 10:08:43 GMT

Hi,

can you tyr something like belw:

=if(GetPossibleCount(Area)=1,Area,'')&' '&

if(GetPossibleCount(Country)=1,Country,'')&' '&

if(GetPossibleCount(company)=1,company,'')

Re: Drill down requirement

madhumitha — Tue, 17 Oct 2017 10:59:50 GMT

Hi Kishor,

Please try this

GetFieldSelections(Area,',',100)&' '& GetFieldSelections(Country,',',100)&' ' & GetFieldSelections(company,',',100)&' ' & GetFieldSelections(Region,',',100)

Thanks!

Re: Drill down requirement

satheshreddy — Tue, 17 Oct 2017 11:16:18 GMT

Hi Kishor,

use getfieldselection() function and use separator as you want.

getfieldselection(fieldname) &'|'&getfieldselection(fieldname)

Regards

Sathish