Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
How about this in Title instead your variable? PFA
If(GetCurrentField([Region/SalesChannel3])='Dealer_Product', 'Product', GetCurrentField([Region/SalesChannel3]))
@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])))