topic where in load in QlikView

where in load

Anonymous — Tue, 24 Jul 2018 07:30:19 GMT

hi,

how do i write in the script 2 differnt variable

i want that the load will be for field name SORTGROUP = 190 and 193

see exm ' the load is wrong as i write

...

DEDUCTFILE as [number]

Where SORTGROUP='190','193';

SQL SELECT *

...

thanks'

yarin

ogautier62 — Tue, 24 Jul 2018 07:35:49 GMT

may be

Where SORTGROUP='190' or SORTGROUP='193';

is it the question ?

regards

Anonymous — Tue, 24 Jul 2018 07:39:57 GMT

it is the question but your solution deosn't work.

it give me only 190

Anonymous — Tue, 24 Jul 2018 07:42:16 GMT

sory my mistake ,

it's working.

thanks'

Chanty4u — Tue, 24 Jul 2018 07:43:03 GMT

or this

Where match(SORTGROUP,190,193)