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: 
Anonymous
Not applicable

Count if

Hi,

i want a chart function like: count("products" where "price" < 3)

What is the correct syntax?

I got:

Count({<price = {3}>}products)

But whats the operator for "<"?

Count({<price < {3}>}products) there is an error

regards,

Fritz

1 Solution

Accepted Solutions
p_verkooijen
Partner - Specialist
Partner - Specialist

Should be:

Count({$

      <Price = {"<3"}>

     } Products)

Also give this a try : http://tools.qlikblog.at/SetAnalysisWizard/QlikView-SetAnalysis_Wizard_and_Generator.aspx

View solution in original post

3 Replies
jjordaan
Partner - Specialist
Partner - Specialist

You can use Set Analysis for this.

Count({$

      <Price = {<"3"}>

} Products)

p_verkooijen
Partner - Specialist
Partner - Specialist

Should be:

Count({$

      <Price = {"<3"}>

     } Products)

Also give this a try : http://tools.qlikblog.at/SetAnalysisWizard/QlikView-SetAnalysis_Wizard_and_Generator.aspx

jolivares
Specialist
Specialist

It depends, you can use an expression like Jeroen said, but take care of the "

Count({<Price = {"<3"}>} Products)

Or

Count({<Products= {"Sum(Price)<3"}>} Products)