topic Re: Create a Measure to compute for top1 in QlikView

Create a Measure to compute for top1

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

Wish to create a measure where I can calculate the top spending supplier and the amount of spend.

Would like to use this information on my quick summary sheet (not table/chart), hence appreciate if you can help me on this.

Table:

Supplier Sales

ABC-Company 10

ABC-Company 5

XYZ-Company 4

ABC-Company 5

XYZ-Company 8

123-Company 15

Result:

ABC-Company 20

Thanks,

Eric

masismykola — Fri, 18 Aug 2017 08:50:29 GMT

Hi try this in text box as KPI:

=FirstSortedValue(Supplier,-aggr(sum(Sales),Supplier)) &'= '& max(aggr(sum(Sales),Supplier))

masismykola — Fri, 18 Aug 2017 08:51:17 GMT

It will change dynamically

Anonymous — Fri, 18 Aug 2017 09:19:33 GMT

Many thanks Mykola

It works.

Thanks a lot for your reply!