Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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

Tags (3)
1 Reply
Highlighted
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