Calculate the percentile in the data array for the expression

[ZimaBlue]

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!

[edwin]

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? )

[ZimaBlue]

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.

[edwin]

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

[vinieme12]

please post some sample data that best represents your actual dataset