Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: 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.