topic Calculate the percentile in the data array for the expression in App Development

Calculate the percentile in the data array for the expression

ZimaBlue — Thu, 19 May 2022 14:15:08 GMT

Hello!

I want to get a table chart in which I will see the following: partner, keyword, number of customers, percentile (which percentile corresponds to the number of customers for this keyword inside the partner in the row).

I understand that I need to use a fractile to calculate percentiles in qlik sense, but I have not yet managed to figure out how to get a fractile to express the number of customers within a partner group for my table.

partner	keyword	customers	perc (fractile)
p1	k11	10	0.40
p2	k33	5	0.30
p2	k22	20	0.85

Thanks in advance for any tips for this!

Re: Calculate the percentile in the data array for the expression

edwin — Thu, 19 May 2022 15:13:56 GMT

can you pls post what your expression is? i thought i knew how to calculate percentile but based on your sample data, i cant figure out how you got the percentile values (or maybe you are missing other relevant rows in your sample data? )

Re: Calculate the percentile in the data array for the expression

ZimaBlue — Fri, 20 May 2022 06:56:02 GMT

my expression for customers count is

count({<[signup_time]= {">=$(vDateFrom)<=$(vtodayDate)"}>} distinct [user_id])

thus, for each row in my pivot, i get the number of users per keyword-partner pairs. in the last column I want to see which percentile within the partner this keyword occupies by the number of clients.

Re: Calculate the percentile in the data array for the expression

edwin — Fri, 20 May 2022 12:57:09 GMT

this gives you the count not the percentile. my question is given the data sample you have how did you arrive at the percentile? maybe give more illustrative examples that explains the numbers

Re: Calculate the percentile in the data array for the expression

vinieme12 — Sat, 21 May 2022 14:59:42 GMT

please post some sample data that best represents your actual dataset