Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Announcement: Certain actions are currently causing a Page Not Found error. This is a known issue and we are working with the platform vendor to investigate and resolve it.
Highlighted
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
gabriel_kirst
Contributor III

Re: Counting condition

Hi!


You can try this:

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


Regards,

Gabriel


2 Replies
gabriel_kirst
Contributor III

Re: Counting condition

Hi!


You can try this:

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


Regards,

Gabriel


Not applicable

Re: Counting condition

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!