topic Re: Multiple Conditions on 'OR' Set Analysis in QlikView

Multiple Conditions on 'OR' Set Analysis

Anonymous — Mon, 08 Oct 2012 07:28:17 GMT

Hello All,

I have the following Set Analaysis which is counting where TicketId is Type 'Accepted Lead' OR 'Instructed Lead':

Count({$<Type={'Accepted Lead'}>+<Type={'Instructed Lead'}>}TicketId)

I need to include another condition, something like:

Count({$<Type={'Accepted Lead'}>+<(Type={'Instructed Lead'},ProductId -= {'5'})>}TicketId)

But whatever I try doesnt seem to count anything!

Essentially, I need to count the TicketId's where Type = 'Accepted Lead' OR ( 'Instructed Lead' AND ProductId<> 5)

Any help would be greatly appreciated.

Thanks

rajni_batra — Mon, 08 Oct 2012 07:52:53 GMT

i tried expression same as urs n getting output 4, can u plz check is it right or not?

swuehl — Mon, 08 Oct 2012 07:53:12 GMT

Try removing the paranthesis () in your second set modifier:

=Count({$<Type={'Accepted Lead'}>+<Type={'Instructed Lead'},ProductId -= {'2'}>}TicketId)

Mon, 08 Oct 2012 07:57:17 GMT

The expression below, I would solve like the Qlikview expression further below

Essentially, I need to count the TicketId's where Type = 'Accepted Lead' OR ( 'Instructed Lead' AND ProductId<> 5)

=Count(

<Type={'Accepted Lead'}>

<Type={'Instructed Lead'},

ProductId -={5}

}TicketId)

(I updated it a bit, since I realised that ProductId should be excluded only when it is an instructed lead).

Anonymous — Mon, 08 Oct 2012 07:59:24 GMT

try something like below..

Count({$<Type={"Accepted Lead","Instructed Lead"},ProductId = ProductId - {"5"})>}TicketId)

hope that helps..

Anonymous — Thu, 09 Mar 2017 09:06:25 GMT

Try this One:

=Count({$<Type={'Accepted Lead'}>+<Type={'Instructed Lead'},ProductId-={'5'}>}TicketId)

shraddhawalekar — Thu, 18 Apr 2019 04:31:16 GMT

Use exclude function,it will help

=Count({<Type={'Accepted Lead'}> + <Type={'Instructed Lead'},ProductId =e({<ProductId={5}>})>}TicketId).