Qlik Community

QlikView Expressor

Discussion Board for collaboration related to QlikView Expressor.

el_lloydie
New Contributor III

Show top 80% of spend

Good morning guys


I'm after some more help if possible please.

SupplierYTD Spend (£)
Supplier C55082544.02
Supplier N7080656.50
Supplier P6481116.09
Supplier L8312827.59
Supplier D26443274.72
Supplier F16021954.61

In the table above, I am looking for an expression that will only show the top 80% spends of the cumulative total in the spend table listed above. Carrying it out as a Dimension limit throws back all kinds of weird and wonderful things.

I appreciate your help,

Gareth

1 Solution

Accepted Solutions

Re: Show top 80% of spend

1 Reply

Re: Show top 80% of spend

Community Browser