topic Re: Replace dimension name in Bar chart in QlikView

Replace dimension name in Bar chart

NurulAin — Mon, 14 Jan 2019 07:45:32 GMT

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".

Re: Replace dimension name in Bar chart

Gysbert_Wassenaar — Mon, 14 Jan 2019 09:02:58 GMT

You can use a calculated dimension in which you replace the values with other values using an if statement. But a better solution is to replace the values in the load script. Or create an extra field in the load script where you replace the values.

Re: Replace dimension name in Bar chart

NurulAin — Mon, 14 Jan 2019 09:04:50 GMT

Hi Gysbert, could you share with me how to do the if statement or what to type in the script?

Re: Replace dimension name in Bar chart

Gysbert_Wassenaar — Mon, 14 Jan 2019 10:08:28 GMT

LOAD
If(Market = 'Not Applicable', 'HUB', If(Market = 'Papua New Guinea', 'PNG',Market)) as Market,
...other fields...
FROM ...source....

Re: Replace dimension name in Bar chart

NurulAin — Mon, 14 Jan 2019 09:41:11 GMT

I tried to follow this script, but when i reload there is an error message as in the picture. what did i do wrong?

LOAD

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

Re: Replace dimension name in Bar chart

bvssudhakar — Mon, 14 Jan 2019 09:43:27 GMT

Hi @Gysbert_Wassenaar

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

Re: Replace dimension name in Bar chart

bvssudhakar — Mon, 14 Jan 2019 09:45:01 GMT

Hi @NurulAin

Can you please share your Script

Re: Replace dimension name in Bar chart

Gysbert_Wassenaar — Mon, 14 Jan 2019 09:47:30 GMT

Replace 'Market' with the name of the field that contains the values you want to replace.

Re: Replace dimension name in Bar chart

bvssudhakar — Mon, 14 Jan 2019 09:47:52 GMT

Hi @NurulAin

Sorry not script, Share your Excel file

Re: Replace dimension name in Bar chart

Gysbert_Wassenaar — Mon, 14 Jan 2019 10:08:07 GMT

=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.

Re: Replace dimension name in Bar chart

NurulAin — Mon, 14 Jan 2019 10:24:41 GMT

Sure, the excel file as attached. so many tabs there - i am using data from Initiatives tab. The Market field is in Column J.