topic Re: where at script with many values in QlikView

where at script with many values

Anonymous — Mon, 11 Jan 2016 06:13:54 GMT

hi,

i write at the end of script like this :"

FROM

D:\QLIKVIEW\QVD\KAPCKLOG.QVD

(qvd)//;

where [מבצע השינוי] = 'A444';"

how do i add another value 'A444' and 'ABC' ?

thanks'

yarin.

tamilarasu — Mon, 11 Jan 2016 06:18:14 GMT

Try,

Where Match(FieldName,'A444','ABC');

MayilVahanan — Mon, 11 Jan 2016 06:18:30 GMT

Try like this

FROM

D:\QLIKVIEW\QVD\KAPCKLOG.QVD

(qvd)

where Match( [מבצע השינוי] ,'A444', 'ABC');

Kushal_Chawda — Mon, 11 Jan 2016 06:18:44 GMT

where match([מבצע השינוי] , 'A444','ABC')

rajeshforqlikvi — Mon, 11 Jan 2016 06:28:39 GMT

You can use like like this alos

where [מבצע השינוי] = 'A444' and [מבצע השינוי] ='ABC' ;

but Match() function is the good option to use.

Regards

Rajesh Kumar