Discussion Board for collaboration on QlikView Layout & Visualizations.
I have a list box with something around 2500 fields on that particular list box i have one value "LEGAL & CUSTOMER COMMUNICATION" and i want to display only that value as LEGAL & CC.
Thanks in advance
Go to Solution.
Please see the attachment for demo.
Try like this:
if(filedname='LEGAL & CUSTOMER COMMUNICATION','LEGAL & CC',filedname)
Thankyou Avinash and Amit
I am using
= if([Function Name] = 'LEGAL / CORPORATE AFFAIRES', 'LEGAL & CA', Upper([Function Name]))
This in list box expression, but my always selected one value is not working and function name mapping also disabled..... any idea?
Use this expression in the script, this will solve the issue
Thanks a lot Aninash