Count if

[Anonymous]

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

[jjordaan]

You can use Set Analysis for this.

Count({$

      <Price = {<"3"}>

} Products)

[PaulVerkooijen_DataFix · Accepted solution]

Should be:

Count({$

      <Price = {"<3"}>

     } Products)

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

[jolivares]

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)