topic where claus in QlikView

where claus

Mon, 10 Nov 2014 13:06:40 GMT

hi,

i want to execute this query in qlikview:

select count(field) where field='value1' or field='value2'

Re: where claus

PrashantSangle — Mon, 10 Nov 2014 13:09:32 GMT

Hi,

Through set analysis try like

Count({<field={'value1,value2'}>}field)

try

count(if(wildmatch(field,'value1','value2'),field))

Regards

Re: where claus

alexandros17 — Mon, 10 Nov 2014 13:10:09 GMT

you have forgotten the table:

select .... FROM TABLE where ...

Re: where claus

MK_QSL — Mon, 10 Nov 2014 13:11:00 GMT

COUNT({<field = {'value1','value2'}>}Distinct field)

COUNT({<field = {'value1','value2'}>}field)

Re: where claus

Anonymous — Mon, 10 Nov 2014 13:11:26 GMT

Try with this in the script:

DataTable:

LOAD Count(field) as numberfield

FROM yoursource

WHERE field='value1' or field='value2';

Marc.

Re: where claus

Mon, 10 Nov 2014 13:19:44 GMT

i want to execute these requests in text object:

select field where field='value1' and 'value2'

and also:

select count(VAR1) where field='value1' and 'value2'

Re: where claus

anbu1984 — Mon, 10 Nov 2014 13:21:23 GMT

Your sql is correct except "From Table" as mentioned by Alessandro.

Do you want to know how to connect to database and execute the sql?

Re: where claus

anbu1984 — Mon, 10 Nov 2014 13:22:53 GMT

=count({$<field={'value1','value2'}>}VAR1)

Re: where claus

Mon, 10 Nov 2014 13:23:55 GMT

the table is not a problem for me, i want just to execute those request in qlik, that's all,

Re: where claus

Mon, 10 Nov 2014 13:33:57 GMT

thank the second request works, but how i can execute the first one:

select field where field='value1' and 'value2'

Re: where claus

anbu1984 — Mon, 10 Nov 2014 13:36:46 GMT

=Concat({$<field={'value1','value2'}>}Field1,',')

Re: where claus

PrashantSangle — Mon, 10 Nov 2014 13:37:09 GMT

Hi,

Use if statement

count(if(wildmatch(field,'value1') and wildmatch(field,'value2'),field))

Regards