topic Custom sorting in Qlikview straight table in QlikView

Custom sorting in Qlikview straight table

miranrai — Fri, 23 Mar 2018 03:35:14 GMT

Hi,

I have a straight table which is showing top n products by their sales. I have to sort these products by top n desc and it should show top n values + others by date except product = car. Car should always appear at the bottom after others even if its not part of top n. Please help. Attached is the sample QV app.

Re: Custom sorting in Qlikview straight table

tresB — Fri, 23 Mar 2018 04:57:36 GMT

Try like:

Calculated dimension:

=Aggr(If(Rank(Sum({<Product-={'Car'}>}Sales))<=vTopN, Product, if(Product='Car', Product, 'Others')), Product)

Sort Desc by expression:

=Aggr(If(Rank(Sum({<Product-={'Car'}>}Sales))<=vTopN, Sum(Sales), if(Product='Car', -2, -1)), Product)

Re: Custom sorting in Qlikview straight table

miranrai — Fri, 23 Mar 2018 06:11:27 GMT

Perfect! Thank you Tresesco