Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Should be:
Count({$
<Price = {"<3"}>
} Products)
Also give this a try : http://tools.qlikblog.at/SetAnalysisWizard/QlikView-SetAnalysis_Wizard_and_Generator.aspx
You can use Set Analysis for this.
Count({$
<Price = {<"3"}>
} Products)
Should be:
Count({$
<Price = {"<3"}>
} Products)
Also give this a try : http://tools.qlikblog.at/SetAnalysisWizard/QlikView-SetAnalysis_Wizard_and_Generator.aspx
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)