topic Re: Qlik Sense Python Integration - calling functions with 2 parameters e.g. numpy.percentile in Integration, Extension & APIs

Qlik Sense Python Integration - calling functions with 2 parameters e.g. numpy.percentile

rbartley — Tue, 28 Sep 2021 13:10:04 GMT

Hi everyone,

I have been able to successfully call other numpy methods such as mean, median, var and std that take only one parameter by using this type of expression:

ScriptPandas.ScriptAggr('qResult = q.std()',Value)

However, the percentile method requires at least 2 parameters https://numpy.org/doc/stable/reference/generated/numpy.percentile.html

numpy.percentile(a, q, axis=None, out=None, overwrite_input=False, interpolation='linear', keepdims=False)

Re: Qlik Sense Python Integration - calling functions with 2 parameters e.g. numpy.percentile

rbartley — Wed, 29 Sep 2021 10:34:48 GMT

In case anyone has a similar question, I satisfied the requirement by taking a different approach: by using the pandas quantile method together with the following expression in order to return the 25th quantile:-

ScriptPandas.ScriptAggr('qResult = q.quantile(0.25)',Value)

Re: Qlik Sense Python Integration - calling functions with 2 parameters e.g. numpy.percentile

rbartley — Tue, 05 Oct 2021 15:40:59 GMT

Ok, I finally found it:-

SSEPython.ScriptAggrEx('D', 'numpy.percentile(args[0][0],85)',Value)

Where the parameter args[0][0] is the field and 85 is the 85th percentile.