Discussion Board for collaboration related to QlikView App Development.
Hi, i have the following charts and need to change the dimension name "Not applicable" to "HUB" and "Papua New Guinea" to "PNG". Can someone show me how to go about this?
Dimension used in this is "Market".
Hi Gysbert, could you share with me how to do the if statement or what to type in the script?
If(Market = 'Not Applicable', 'HUB', If(Market = 'Papua New Guinea', 'PNG',Market)) as Market,
I tried to follow this script, but when i reload there is an error message as in the picture. what did i do wrong?
If(Market = 'Not Applicable', 'HUB', If(Market = 'Papua New Guinea', 'PNG')) as Market
From [C:\Users\nain\Digicel Caribbean Ltd\Performance Transformation Pacific - Documents\03 Reports\05 Tracker WAVE\00 Archive - Latest Data\Latest data - Wave - 20190113 (17h39m).xlsx];
Can you please write it as calculated dimension also because i want to know how to write in calculated dimension in this type condition
Thank you in advance
B V S Sudhakar
Can you please share your Script
Replace 'Market' with the name of the field that contains the values you want to replace.
Sorry not script, Share your Excel file
=If(Market = 'Not Applicable', 'HUB', If(Market = 'Papua New Guinea', 'PNG',Market))
And again use the real field name if it's not named Market.