topic Re: Set Modifier With Fractile Function in QlikView

Set Modifier With Fractile Function

Anonymous — Mon, 28 Oct 2013 14:18:59 GMT

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)

Re: Set Modifier With Fractile Function

Clever_Anjos — Mon, 28 Oct 2013 14:24:11 GMT

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)

Re: Set Modifier With Fractile Function

Anonymous — Mon, 28 Oct 2013 14:31:17 GMT

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.