Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Counting condition


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!

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Hi!


You can try this:

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


Regards,

Gabriel


View solution in original post

2 Replies
Anonymous
Not applicable
Author

Hi!


You can try this:

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


Regards,

Gabriel


Not applicable
Author

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!