Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
jim_chan
Specialist
Specialist

how to change a cylic group dimension label?

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

 

screenshot1.jpgThank you.

 

Jim

Labels (2)
6 Replies
uacg0009
Partner - Specialist
Partner - Specialist

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
Specialist
Specialist
Author

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]))

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
jim_chan
Specialist
Specialist
Author

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
Partner - Specialist
Partner - Specialist

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])))

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful