how to change a cylic group dimension label?

[jim_chan]

Hi guys, 

I have created a cylic group with dimensions in it. and i need to use it as the Window Title as well. 

Problem is - when it changed to Dealer_product, on my window title , it does change to the field name i have put in label - as "Product". 

So, how to change it so it will show "Product" instead of "Dealer_product" in the window title? Please help.

I have attached my sample file here as well - testing.qvw

Variable: vCyclicRegionChannelName

Expression/Definition: Capitalize(replace(GetCurrentField("Region/SalesChannel3"),'TEST_',''))

Cyclic Group Name: Region/SalesChannel3

Thank you.

Jim

[uacg0009]

Hi Jim,
I'm not sure whether qlikview can get the "label" of cyclic group in window title, but I think it's hard to do it.
If you only have 2 columns in cyclic group, do you mind hard-coding it?
like : =Capitalize(replace(GetCurrentField("Region/SalesChannel3"),'Dealer_',''))
Or if it's possible for you, you can also "as" the column name in your back-end script.
Aiolos

[jim_chan]

Thanks uacg0009,

what if the fieldname is "Dealer_Product_Name", then how to remove the "Dealer_ & _Name"?

in the script, i can see that actually removed "Dealer_", with this 'Dealer_','')). 

Rgds

Jim

[Anil_Babu_Samineni]

How about this in Title instead your variable? PFA

If(GetCurrentField([Region/SalesChannel3])='Dealer_Product', 'Product', GetCurrentField([Region/SalesChannel3]))

[jim_chan]

Thanks Loveisfail,

what if the fieldname is "Dealer_Product_Name", then how to remove the "Dealer_ & _Name"?

in the script, i can see that actually removed "Dealer_", with this 'Dealer_','')).



Rgds

Jim

[uacg0009]

Hi Jim,
Firstly I think if you remove the "Dealer_" in the back-ground, then you will see the column name is "Product" I think.
Secondly I think normally we already know what the field name is, like it's "Dealer_Product" or "Dealer_Product_Name", it won't change.
You can write a "if" function to change all names to what you want.
Or you can also create a mapping table in back-ground.
Aiolos

[Anil_Babu_Samineni]

@jim_chan Usually, GetCurrentField() picks based on dimension not the label.

Now, For your answer - The way i can think If..Else statement during the period using like

If(GetCurrentField([Region/SalesChannel3])='Dealer_Product', 'Product', If(GetCurrentField([Region/SalesChannel3])='Dealer_Product'_Name, 'Product Name',  GetCurrentField([Region/SalesChannel3])))