Fractile function error

satishkurra — Sat, 26 May 2018 13:16:22 GMT

Attached is the sample data and app.

It has 2 expressions

1. Revenue/Hours

2. Hours

I'm trying to display in scatter plot using dimension ID

Also the current logic is to display ID's between 5 and 95 percentile. Hence i used FRACTILE function.

However when i select random data, attached is the image and highlighted in RED, it is saying NO DATA TO DISPLAY.

Now i'm trying to get to the state of achieving between (StdDev * -0.5 + Mean) and (StdDev * 0.5 + Mean)

Please help me on the same

Thanks

Satish

topic Fractile function error in QlikView