window title change based on drill down group switch

[Anonymous]

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

[#2]

Hi,

Try using the below code in expression for Windows title:

='Inspections by '

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

[Anonymous]

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

[Anonymous]

... or maybe even just :

     ='Inspections by ' & [Used Dimensions]

I suspect there are other issues in the qvw.

[Anonymous]

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

[Anonymous · Accepted solution]

Maybe something like this :

='Inspections by ' &

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

GetCurrentField(_DD) ,

GetCurrentField(Group2)

)

[#7]

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'

  )

  ))

[Anonymous]

Hi Bill,

Thanks for Your Time.

Its worked for me.let me test once again .

Thanks you very much.

[Anonymous]

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

[Anonymous]

Hi Jemimah,

Thanks for your Time.

Your solution also working fine .

Thank you very Much.