Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everybody,
I'm trying actually to solve a problem concerned a Qlikview dashboard,
The dashbord takes some information about differents plant in Canada. I have to change the name of one of them in the report without changing the name in the database.
For exemple: I have a windows that contain name of plant, them adresses, rate, ...etc. The name of one of those plants is ABS, and I want that the name change to AAA. I know that i have to use an If statement in my proprieties, but i don't know where can i put it, and what's the correct form of the request.
Thank you for your support!!
Hi Walid,
If you a Chart and using the Name of the Plant as one of your dimanesion, you can use 'If' condition.
For Example:
If you want to change the name of the plant from ABS to AAA,
you can use:
=if(Name_of_Plant = 'ABS', 'AAA', Name_of_Plant)
What this will do is whenever the name ABS comes in the report, it will change it to AAA and otherwise it will fetch the data from the field Name_of_Plant.
I hope this might help your query..
Hi,
In script you can do like this
Data:
LOAD
If(Name_of_Plant = 'ABS', 'AAA', Name_of_Plant) AS Name_of_Plant,
'
'
'
FROM DataSource;
Hope this helps you.
Regards,
Jagan.
Hi everybody,
Thank you for your responses. I tried to do what you told, but my request did not work.
This is my script
MAPPING LOAD DISTINCT
LDE_VALUE, // DC Code
INT_DESC, //DC Name
If(INT_DESC = 'MANTENO DC', 'YC Kennewick Coldstor DC', INT_DESC) AS DC
FROM
INT_XREF.qvd
(qvd)
WHERE
upper(trim(INT_TYPE)) = 'PLT';
I want to change the display from 'MANTENO DC' to 'YC Kennewick Coldstor DC'
Thank you so much for your help
Hi
You are using mapping load? so you can use only two fields in it. So try like this
MAPPING LOAD DISTINCT
LDE_VALUE, // DC Code
If(INT_DESC = 'MANTENO DC', 'YC Kennewick Coldstor DC', INT_DESC) AS DC
FROM
INT_XREF.qvd
(qvd)
WHERE
upper(trim(INT_TYPE)) = 'PLT';
Hi,
I tried it. Nothing has changed. 'MANTENO DC' is always on the dashboard....
Thank you for help
Hi,
I tried it. Nothing has changed. 'MANTENO DC' is always on the dashboard....
Thank you for help
Hi
Can you provide a sample file
Hi Walid,
You are using mapping load, Are you using this data with applymap in another load? If not then this table will be gone after your load is complete.
If yes try, just a shot hope you have no empty space in data.
If(trim(INT_DESC) = 'MANTENO DC', 'YC Kennewick Coldstor DC', INT_DESC) AS DC
Hi,
Have you tried using the REPLACE Function in your script
REPLACE(Plant,'ABS','AAA') AS Plant
or create a list box expression
REPLACE(Plant,'ABS','AAA')
HTH
Regards
Al