topic Re: Multiple conditions // Error in QlikView

Multiple conditions // Error

Thu, 28 May 2015 09:08:16 GMT

Hi Community,

Quick question: I am stuck with below example.

Eg. John has 206 saved sessions with 76 ABs (Value='yes') and another 37 with BCs and another 9 CDs.

I am trying to get the number of distinct sessions with ABs and (BCs or CDs).

When I put the formula as below, it does not give me a result.

User	DISTINCT SessionIDs	AB	BC	CD	Count(DISTINCT if(AB = 'yes' and BC='yes' or CD='yes', SessionID, Null())
John	206	76	37	9	-
Andy	1	0	0	0	-
Chris	118	17	11	8	-
Alex	244	40	36	0	-
Peter	200	11	15	15	-
Matt	228	16	19	12	-

I would highly appreciate if someone could help me out. Is there a syntax error or a problem with the "and" / "or" usage?

Many thanks in advance!

Re: Multiple conditions // Error

Peter_Cammaert — Thu, 28 May 2015 09:11:43 GMT

Start by putting parentheses around ( BC='yes' or CD='yes' ). Usually an OR has lower order of precedence.

Re: Multiple conditions // Error

datanibbler — Thu, 28 May 2015 09:12:07 GMT

Hi,

you must take care of your brackets.

In your example, you should put it like >> IF(AB = 'yes' AND (BC = 'yes' or CD = 'yes') <<

=> That will count the records where

- AB is true

- AND (either BC or CD) is true

HTH

Re: Multiple conditions // Error

Peter_Cammaert — Thu, 28 May 2015 09:26:50 GMT

Is this an example of what you're trying to accomplish ?

Note that a complex datamodel (i.e. one where fields are located in different tables) may provide poor performance or fail to produce correct results..

Peter

Re: Multiple conditions // Error

maxgro — Thu, 28 May 2015 19:01:49 GMT

=count(DISTINCT {$ <AB={yes}>*(<BC={yes}>+<CD={yes}>)} SessionID)