Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
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.