Re: where claus - Page 2 - Qlik Community

Report Inappropriate Content · ‎2014-11-10

hi,

i want to execute this query in qlikview:

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

anbu1984 · ‎2014-11-10

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

PrashantSangle · ‎2014-11-10

Hi,

Use if statement

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

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂