Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi,
i want to execute this query in qlikview:
select count(field) where field='value1' or field='value2'
Hi,
Through set analysis try like
Count({<field={'value1,value2'}>}field)
or
try
count(if(wildmatch(field,'value1','value2'),field))
Regards
you have forgotten the table:
select .... FROM TABLE where ...
COUNT({<field = {'value1','value2'}>}Distinct field)
or
COUNT({<field = {'value1','value2'}>}field)
Try with this in the script:
DataTable:
LOAD Count(field) as numberfield
FROM yoursource
WHERE field='value1' or field='value2';
Marc.
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'
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?
=count({$<field={'value1','value2'}>}VAR1)
the table is not a problem for me, i want just to execute those request in qlik, that's all,
thank the second request works, but how i can execute the first one:
select field where field='value1' and 'value2'