topic Re: multi condition in where clause in QlikView

multi condition in where clause

Sun, 03 Jan 2016 18:12:12 GMT

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

sunny_talwar — Sun, 03 Jan 2016 21:59:20 GMT

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

Oleg_Troyansky — Sun, 03 Jan 2016 22:35:29 GMT

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 — Mon, 04 Jan 2016 04:35:23 GMT

Hi,

can you post u r sample data.

-Hirish

Mon, 04 Jan 2016 05:44:45 GMT

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

thanks

sunny_talwar — Mon, 04 Jan 2016 11:45:56 GMT

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

Mon, 04 Jan 2016 19:30:53 GMT

thanks oleg that works

thanks all

sunny_talwar — Mon, 04 Jan 2016 19:36:45 GMT

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

Best,

Sunny