Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
agenorcanal
Contributor III
Contributor III

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
sunny_talwar

What is the expected output from this data?

agenorcanal
Contributor III
Contributor III
Author

Hi Sunny,

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