topic Re: IF and AND in the same expression in QlikView

IF and AND in the same expression

Tue, 12 Aug 2014 19:34:24 GMT

Hi Community,

I need to count NULL registers, when 2 conditions are required at the same time. I've try with

=COUNT(IF([Fecha de devolución a cedente]='' AND [Fecha de recepción]= '') id_counter1) but no luck. I'd appreciate if you could bring some light in my darkness!

Thanks in advance for your help!

Regards,

Vincent

Re: IF and AND in the same expression

Tue, 12 Aug 2014 19:37:19 GMT

Try:

COUNT( IF ([Fecha de devolución a cedente]='' AND [Fecha de recepción]= '', id_counter1) )

Re: IF and AND in the same expression

Tue, 12 Aug 2014 19:58:49 GMT

Hi Ajay,

It hasn't worked, but I've finally managed to do it.

FYI:

= COUNT( IF (IsNull([Fecha de devolución a cedente]) AND IsNull([Fecha de recepción]) , id_counter1 ) )

Regards,

Vincent

Re: IF and AND in the same expression

jagan — Wed, 13 Aug 2014 03:26:20 GMT

Hi Vincent,

You can try this in set analysis

= COUNT({<[Fecha de devolución a cedente]-= {'*'}, [Fecha de recepción]-={'*'}>} id_counter1 )

Regards,

Jagan.