Fractile function with direct query on Google BigQuery
Hello,
I am using Qlik Cloud and leveraging a large dataset in BigQuery. I have setup up direct query successfully to start building analytics.
I am facing an issue with the Fractile function. I need to generate 99%, 99.9% quantiles and the direct query seems to only support basic aggregation functions.
I have tried to define a Fractile measure. Qlik is accepting the expression and then generating SQL with the Fractile function in BigQuery. BigQuery computes quantiles thanks to different functions but Fractile() is not one of them.
The trick is that Fractile cannot be preaggregated. It needs to run on the full dataset.
