topic Re: Display only the Sales with highest SL's in QlikView

Display only the Sales with highest SL's

satishkurra — Wed, 15 Jun 2016 17:40:43 GMT

In the below data, i need to display only SL's with highest Sales.

For example, INDIA has highest SL for SL3. I should be displaying only 1500 against INDIA and SL3

In the same way USA has highest SL for SL1. I should be displaying only 3000 against USA and SL1

I'm trying to achieve this in a Pivot Table by dragging the SL column to show column wise...

LOAD * Inline [

Country,SL,Sales

INDIA,SL1,1000

INDIA,SL2,900

INDIA,SL3,1500

USA,SL1,3000

USA,SL2,1000

USA,SL3,2000 ];

Can someone help me on the same?

Thanks

Satish

satishkurra — Wed, 15 Jun 2016 17:47:43 GMT

In b/w i'm using Dimension 1 as Country, Dimension 2 as =FirstSortedValue(SL, - aggr( distinct sum(Sales),SL ) )

and expression as Sum(Sales)

sunny_talwar — Wed, 15 Jun 2016 17:58:27 GMT

How about using two expression and one dimension in a straight table?

sunny_talwar — Wed, 15 Jun 2016 18:01:05 GMT

Or this where expression is Max(Sales) instead of Sum(Sales)