topic Problem with an complex if clausel in QlikView

Problem with an complex if clausel

qlikconsultant — Wed, 16 Jan 2013 11:56:14 GMT

I have the following Data:

I want the following:

I use a chart table to count the following:

if ( ID<>0 and isnull(ID)=0 and(Direct=1 or Search=1),count(ID) ,0)

dimension is date and time. The result from that example should be 2 but I get 0. Any idea what I doing wrong?

Wed, 16 Jan 2013 12:09:03 GMT

Hallo Markus,

could you display the ID and Count(ID) in the table?

Perhaps the problem is there.

Ciao

Klaus

swuehl — Wed, 16 Jan 2013 12:12:34 GMT

You'll need to embed the condition in the aggregation, not the other way round:

=count( if ( ID<>0 and isnull(ID)=0 and(Direct=1 or Search=1),ID))

Anonymous — Wed, 16 Jan 2013 12:14:13 GMT

is this a case of conductig your tests across the whole set of data, as opposed to at the level of datapoints ?

Try something like:

count(if ( ID<>0 and isnull(ID)=0 and(Direct=1 or Search=1),ID)

Jonathan