topic Re: IF statement in QlikView

IF statement

Tue, 05 Nov 2013 20:58:40 GMT

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!!

Re: IF statement

Wed, 06 Nov 2013 05:15:41 GMT

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

Re: IF statement

jagan — Wed, 06 Nov 2013 05:55:56 GMT

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.

Re: IF statement

Wed, 06 Nov 2013 15:46:49 GMT

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

Re: IF statement

MayilVahanan — Wed, 06 Nov 2013 15:51:14 GMT

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

Re: IF statement

Wed, 06 Nov 2013 15:57:38 GMT

Hi,

I tried it. Nothing has changed. 'MANTENO DC' is always on the dashboard....

Thank you for help

Re: IF statement

Wed, 06 Nov 2013 15:57:58 GMT

Hi,

I tried it. Nothing has changed. 'MANTENO DC' is always on the dashboard....

Thank you for help

Re: IF statement

MayilVahanan — Wed, 06 Nov 2013 20:04:43 GMT

Can you provide a sample file

Re: IF statement

Wed, 06 Nov 2013 20:10:18 GMT

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

Re: IF statement

rustyfishbones — Wed, 06 Nov 2013 20:23:42 GMT

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