topic Re: window title change based on drill down group switch in QlikView

window title change based on drill down group switch

Anonymous — Thu, 09 Jul 2015 10:13:32 GMT

Hi Gurus,

i have 2 groups.

1._DD

2.group2

If i select Year from used dimensions list window title showing Inspections By year.its fine

if i select region it should show Inspections by region

i have expression like below for window Title:

='Inspections '

&pick( WildMatch(GetCurrentField(_DD)

,'*Year*','*Region*','*Health Authority*','*Site*','*GXP Area*','*Site Type*','*Phase*')

,'by Year'

,'by Region'

,'by Health Authority'

,'by Site'

,'by GXP Area'

,'by Site Type'

,'by Phase'

)

I want the same to implement for Group 2 Drilldown if user selects Region field.

Please find the attached application

Re: window title change based on drill down group switch

Thu, 09 Jul 2015 10:30:12 GMT

Hi,

Try using the below code in expression for Windows title:

='Inspections by '

&if(not match([Used Dimensions],'Category','Assessment','Department'),[Used Dimensions])

Re: window title change based on drill down group switch

Anonymous — Thu, 09 Jul 2015 10:34:42 GMT

if i click Year from Used dimensions List ,_DD Drilldown will Activate.

if i select Region from Used dimensions List ,Group 2 Drilldown will Activate.

same window title should swith between _DD& Group2 Drilldowns Based on Selected one

Problem is how to include Group 2 Drill down name in the same expression

Re: window title change based on drill down group switch

Anonymous — Thu, 09 Jul 2015 10:36:10 GMT

... or maybe even just :

='Inspections by ' & [Used Dimensions]

I suspect there are other issues in the qvw.

Re: window title change based on drill down group switch

Anonymous — Thu, 09 Jul 2015 10:41:09 GMT

can u suggest if there are any other issues.

I tried ur suggestion ='Inspections by ' & [Used Dimensions]

if i use above ,if i select year -> after i will drill down to Region->after i will drilldown to health Authority.

so, window title not matching with regions,health Authority

Re: window title change based on drill down group switch

Anonymous — Thu, 09 Jul 2015 10:42:21 GMT

Maybe something like this :

='Inspections by ' &

if ( SubStringCount(Concat(DimFlag,'|'),1) ,

GetCurrentField(_DD) ,

GetCurrentField(Group2)

)

Re: window title change based on drill down group switch

Thu, 09 Jul 2015 10:51:14 GMT

Will this be ok:

='Inspections '

&if(DimFlag=1,pick( WildMatch(GetCurrentField(_DD)

,'*Year*','*Region*','*Health Authority*','*Site*','*GXP Area*','*Site Type*','*Phase*')

,'by Year'

,'by Region'

,'by Health Authority'

,'by Site'

,'by GXP Area'

,'by Site Type'

,'by Phase'

if(DimFlag=2,pick( WildMatch(GetCurrentField(Group2)

,'*Region*','*Health Authority*','*Site*','*GXP Area*','*Site Type*','*Phase*')

,'by Region'

,'by Health Authority'

,'by Site'

,'by GXP Area'

,'by Site Type'

,'by Phase'

)

))

Re: window title change based on drill down group switch

Anonymous — Thu, 09 Jul 2015 10:53:07 GMT

Hi Bill,

Thanks for Your Time.

Its worked for me.let me test once again .

Thanks you very much.

Re: window title change based on drill down group switch

Anonymous — Thu, 09 Jul 2015 10:57:52 GMT

... and don't forget to tag replies as Helpful / Correct.

Re: window title change based on drill down group switch

Anonymous — Thu, 09 Jul 2015 11:38:48 GMT

Hi Jemimah,

Thanks for your Time.

Your solution also working fine .

Thank you very Much.