topic Re: If....Where in QlikView

If....Where

Sun, 06 Jul 2014 21:47:42 GMT

Hi,

I have table bellow, the code for CCC is empty, my need is : if type is '3', then show the code of the same customer where type is 1 .

The final table will be like bellow

how to proceed?

Sun, 06 Jul 2014 21:57:39 GMT

Hi,

You can try something like the attached text file within your script.

Hope this helps.

jagan — Mon, 07 Jul 2014 02:10:58 GMT

Hi,

Try like this

Data:

LOAD

CUSTOMER,

NAME,

TYPE

IF(TYPE= 3, '103', CODE) AS CODE

FROM DataSource;

Regards,

Jagan.