Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Set Modifier With Fractile Function

I have a table with sales by SKU and a separate data island with a fractile dimension and fractiel percentages. I'm trying to count the number of SKUs with sales greater than or equal to the fractile percentage, however, I'm getting no results. What am I missing in the syntax for the chart expression below?

Count({<Sales_Value = {">=Fractile (Sales_Value,Percent)"}>} SKU)

2 Replies
Clever_Anjos
Employee
Employee

First test: change Percent to a fixed value, 0.1 for example and change the expression to

Count({<Sales_Value = {">=$(=Fractile (Sales_Value,0.1))"}>} SKU)

Anonymous
Not applicable
Author

Still no results. Just to make sure there was nothing wrong with either table, I added a chart expression of just Fractile (Sales_Value,Percent) and I get the correct results.