topic Re: Expression using or, and in QlikView

Expression using or, and

Fri, 13 Apr 2012 11:29:22 GMT

I need do a expression like this:

=count({$<B1_SU = {"8"} .or. B1_SU = {"12"}>} D2_QUANT)

Many conditions with the same field

it's possible?

jagan — Fri, 13 Apr 2012 11:36:49 GMT

Hi,

What is the condition to use B1_SU = {"8"} and B1_SU = {"12"}. Try this

=count({$<B1_SU = {"$(=If(Condtion, 8, 12))"}>} D2_QUANT)

Regards,

Jagan.

CELAMBARASAN — Fri, 13 Apr 2012 11:37:44 GMT

Hi,

Check with this

=count({<B1_SU = {8}>+<B1_SU = {12}>} D2_QUANT)

using set operators

Celambarasan

erichshiino — Fri, 13 Apr 2012 15:23:46 GMT

It can be very simple:

count({$<B1_SU = {'8','12'}>} D2_QUANT)

or even

count({$<B1_SU = {8, 12}>} D2_QUANT)

Regards,

Erich

Anonymous — Thu, 17 Jan 2013 17:56:17 GMT

That works when it's a single column basing on two values but what about an "or" when it's two values

Using the above example:

This is assuming both values are in B1_SU

count({$<B1_SU = {'8','12'}>} D2_QUANT)

but what if I am looking at

B1_SU = {'8','12'} or B2_SU = {'3','5'}

So the "or" is based on two different columns.

Thanks

nagaiank — Thu, 17 Jan 2013 18:11:39 GMT

You may use

count({$<B1_SU = {8, 12}> + <B2_SU = {3, 5}>} D2_QUANT)