Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
qvmyself
New 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

Tags (3)
1 Reply
MVP
MVP

Re: AGGR/fractile - dimension problem

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

Community Browser