Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
mys-elf
Contributor
Contributor

AGGR/fractile - dimension problem

Hi all,

I got a table with lots of prices which I calculate by the revenue and the quantity. Now I want to split theses prices by the fractile function and aggregate them by one or two dimensions (product (and department)).

DepartmentProductRevenueQuantityPriceq(75%)
A12312026067,50
A12321037067,50
B2341711719,25
B2344022019,25

It should look like that but I don't know how to do it.

Thanks a lot,

Matthias

1 Reply
swuehl
MVP
MVP

Use an expression like

=fractile(total<Department, Product> Revenue/Quantity,0.75)

in a straight table with above dimensions (Departement, Product, Quantitiy, Revenue) or detail what your dimensions and expressions are.

edit: Using price calculation