Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

agenorcanal
New Contributor II

How can I do to find the quartiles, by one variable and weighted by another.

Hi,

How can I do to find the quartiles, by one variable and weighted by another.
For example, in the following data, I wanted the quartiles of the amount variable, by code and weighted by the quantity variable.
Input frame date
    code               amount                     quantity
    1.01                   35867.14                   125
    1.01                 5867.05                     1045
    1.01                62100.14                       91
    1.01                35,000.99                     21
    1.02                401.87                       2650
    1.02                815.7                       10345

Thanks

2 Replies

Re: How can I do to find the quartiles, by one variable and weighted by another.

What is the expected output from this data?

agenorcanal
New Contributor II

Re: How can I do to find the quartiles, by one variable and weighted by another.

Hi Sunny,

To code 1.01: Quartile 0,25 and  Quartile 0,5 and Quartile 0,75 = 5867.05.

Community Browser