Limiting 1 dimension on another dimensions top x

diffeyj — Fri, 15 Dec 2017 03:58:07 GMT

So I have a qvw where by I am showing the top 10 customers by gross profit

Rank	Customer	Gross Profit
1	Customer A	90,000
2	Customer B	80,000
3	Customer C	70,000
...
10	Customer J	40,000

For these top 10 customers I want to show a pie chart by income stream (eg. Private Sector, Government Sector, Mining Sector, etc.). So the dimension on the Pie Chart currently is Income Stream.

So if the top 10 customers didn't include any income from the Mining Sector, I don't want them included in the Pie Chart.

In addition I don't want to include any income from customers not in the top 10. So if out of the top 10 customers, $30,000 was spent on the Private Sector, that slice of the Pie Chart should be $30,000.

Does anyone have any ideas?

I assume I need to do something using the Rank Function, but I can't work out where/how is the best to do it.

The expression is already a set analysis

sum({<isParentJobClosed={0},[Period End Date]= {"<=$(=SelectedPeriodEnd)"}>+<isParentJobClosed={1},ParentJobCompleteDate={">=$(=SelectedFinancialYearStart)"},[Period End Date]= {"<=$(=SelectedPeriodEnd)"}> } SalesLineRetail)

Re: Limiting 1 dimension on another dimensions top x

Anil_Babu_Samineni — Fri, 15 Dec 2017 04:18:35 GMT

From given expression? Won't work for single degrade field. The highlight one ignores.

SelectedPeriodEnd is the field or Variable?

To answer your question, Perhaps this?

sum({<isParentJobClosed={0},[Period End Date]= {"<=$(=SelectedPeriodEnd)"}>+<isParentJobClosed={1},ParentJobCompleteDate={">=$(=SelectedFinancialYearStart)"}, Customer = {"=Rank(Sum([Gross Profit),4)<=10"}> } SalesLineRetail)

topic Limiting 1 dimension on another dimensions top x in QlikView

Limiting 1 dimension on another dimensions top x

Re: Limiting 1 dimension on another dimensions top x