multi condition in where clause

[#1]

how i can inject a multi condition in  where clause for this set analysis :

Only({<sales ={">0"},ID ={'id1','id2','id3'},typeDocument -={'d1','d2','d3'}, PR-={'PE'},type -= {''}>}Document)

where sales >0 and ....

thanks

Re: char table with calculated dimonsion

[sunny_talwar]

Looks right to me, is it not working? or what's the issue?

[Oleg_Troyansky]

Something like this:

WHERE

     sales =>0

and

     Match(ID,'id1','id2','id3') > 0

and

     Match(typeDocument, 'd1','d2','d3') = 0

and

     PR<>'PE'

and

     type <> ''

cheers,

Oleg Troyansky

Take your Qlik Skills to the next level at the Masters Summit for Qlik - now with new and redesigned materials!

[HirisH_V7]

Hi,

can you post u r sample data.

-Hirish

[#5]

hi

no it works but i want to put it in my script but not in the chart tavle

thanks

[sunny_talwar]

Have you tried Oleg Troyansky‌'s provided where statement? I think it should give you what you are looking for.

[#7]

thanks oleg that works

thanks all

[sunny_talwar]

Please mark Oleg's answer as correct to close the thread.

Best,

Sunny