topic Re: labeling values in load statement in QlikView

labeling values in load statement

yelin_nyu — Mon, 05 Nov 2012 18:43:20 GMT

Hi there,

need help on labeling values. Currently in load statement I have a extremely long if statement: if (var='1' or var='x' or var='p' or ........., 'basic', 'special') so for each line within my main table, there is a value for var.

is there a way to make things shorter and more professional?

Re: labeling values in load statement

its_anandrjs — Mon, 05 Nov 2012 18:47:23 GMT

Hi,

Use For loop for different stages calculation.

Regards,

Anand

Re: labeling values in load statement

yelin_nyu — Mon, 05 Nov 2012 18:48:44 GMT

could you provide an example?

Re: labeling values in load statement

MayilVahanan — Mon, 05 Nov 2012 18:50:25 GMT

Try match function

Load *, if(match(var,'1','x','p'),'basic','special') as fieldname from tablename;

Hope it helps'

Re: labeling values in load statement

diegofcaivano — Mon, 05 Nov 2012 18:52:44 GMT

Hi. I believe you need the MATCH() function.

You can compare a unique expression with a list of values a lot easier:

MATCH($(VAR), '1', 'x', 'p', 'special', ...)

Look at QlikView's help description for more examples.

Regards.