topic Re: Counting condition in QlikView

Counting condition

Thu, 05 Mar 2015 14:04:15 GMT

Hi everyone,

I have a table where I present the data in field which is equal to chocolate:

Count

({$<Product={"Choco"}>}Dia)

Now I want to show the numbers of products equal to "Choco" where the price is higher than 3.

Does anyone know how can I accomplish that?

I tried to use the field Condition on the tab Expression but I think it didnt work. Does anyone know how I can put a condition (AND) on the expression?

Thanks in advance!

Re: Counting condition

Anonymous — Thu, 05 Mar 2015 14:11:33 GMT

Hi!

You can try this:

Count({$<Product={"Choco"},Price={">3"}>}Dia)

Regards,

Gabriel

Re: Counting condition

Wed, 13 Jul 2016 13:07:05 GMT

Hi,

I also have difficulties with multiple conditions.

(count({<[Status]={'Perdue'}>} [ID opportunité])) :THIS one WORKS

(count({$<Year = {$(=max(Year ))}, Month= {"<=$(=max({<Year ={$(=max(Year ))}>} Month))"}, [Status]={'Perdue'}>}} [ID opportunité])) :THIS ONE DOESN'T WORK

Any help would be more than appreciated!

thank you!