Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

multi condition in where clause

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

7 Replies

Re: multi condition in where clause

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

Re: multi condition in where clause

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!

hirishv7
Honored Contributor

Re: multi condition in where clause

Hi,

can you post u r sample data.

-Hirish

Not applicable

Re: multi condition in where clause

hi

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

thanks

Re: multi condition in where clause

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

Not applicable

Re: multi condition in where clause

thanks oleg that works

thanks all

Re: multi condition in where clause

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

Best,

Sunny

Community Browser