topic Re: Count or If statement in QlikView

Count or If statement

Wed, 16 Aug 2017 19:25:38 GMT

I am trying to Count all the Shirts that are blue with orders less that 240. However I am putting this data in a filter and keep getting invalid dimension.

Below is the expressions that I wrote. I get an OK from the expression check in Qlik Sense but no display. Not sure what I am doing wrong but any help would be appreciated.

=Count({$<Shirts = {'Blue'} >} [Shirt Orders]<240)

another Expression

=If(Shirts = 'Blue',Count([Shirt Orders]) <240)

Kurleigh

Re: Count or If statement

sunny_talwar — Wed, 16 Aug 2017 19:30:44 GMT

May be this

If(Count({$<Shirts = {'Blue'}>} [Shirt Orders]) < 240, Count({$<Shirts = {'Blue'}>} [Shirt Orders]))

Re: Count or If statement

sunny_talwar — Wed, 16 Aug 2017 19:31:39 GMT

Or this

Count({<Shirts = {'Blue'}*{"=Count({$<Shirts = {'Blue'}>} [Shirt Orders]) < 240"}>} [Shirt Orders])

Re: Count or If statement

Wed, 16 Aug 2017 19:59:38 GMT

Thanks,

I tried the first expression and it returned a blank result. Not sue why I can def see their are blue shirts with orders less that 240.

The second expression gave me and error.

Re: Count or If statement

neha_shirsath — Thu, 17 Aug 2017 05:29:45 GMT

try with this-

if(Shirts='Blue' and [SHirt Orders]<240,Count([SHirt Orders]))

Re: Count or If statement

pathiqvd — Thu, 17 Aug 2017 05:44:11 GMT

Hi,

Try This,

=count({<Shirts={"Blue"},[SHirt Orders]={"<240"}>}[SHirt Orders])

Regards,

Re: Count or If statement

AshutoshBhumkar — Thu, 17 Aug 2017 06:05:54 GMT

Hi,

Try both conditions in set.

Count({<Shirts ={"Blue"},[Shirt Orders]={"<240"}>} [Shirt Orders])

Re: Count or If statement

tresB — Thu, 17 Aug 2017 06:15:13 GMT

I guess if Shirts actually holds color code, there has to be a separate field for shirt itself, may be like ShirtCode. And then, you perhaps could try like:

Count( DISTINCT {<ShirtCode={"=Count({<Shirts={'Blue'}>} [Shirt Orders])<240"}>}ShirtCode)

Note: Adjust the fields in your context.

Edit: DISTINCT

Re: Count or If statement

passionate — Thu, 17 Aug 2017 06:45:47 GMT

Hi Henry,

Provide some data dumps.

The above solutions must work.

Regards,

Pankaj

Re: Count or If statement

Thu, 17 Aug 2017 15:16:31 GMT

Thanks Lakshmipathi,

Your solution with what I was looking for. Also,Thanks everyone for chiming it with help.