Get Current Selections?

[dmac1971]

Lets say my data is something like :

Customer | Region | Sub Region | Country

If I select a particular customer from a list box can I use :

getcurrentselections(Customer)

To return the Region / Sub Region / Country in an expression?  I want to show top 10 sales items for the Customer / Country / Region etc?

Thanks in advance.

[MK_QSL]

Kindly describe briefly or more specifically your requirements...

Dont understand properly.

[#3]

But why?

If you select some customer or make any other selection, QV will propagate it to any other, associated field in entire data model. So, in your expressions you typically don't need to check if something is selected

regards

Darek

[dmac1971]

Yes understand that, however I have more than one customer in each country/region etc.  I want to see the top 10 items for the country for all customers, not just the one selected, hence my thoughts where to return the region/country etc using the getcurrentselections?

Basically I want to emulate vlookup from excel, look up the region, subregion, country etc based on the selected customer?  Thanks.

[#5]

so, you like to select customer(s) and show in your chart top ten customers for each country, where selected customer has any transaction?

[dmac1971]

No.

I can show the selected customer's, chosed from listbox, top 10 items easily.  However based on this selected customer I now want to show the total country and regions top 10 items, including this customer but also all other customers in that country and region.

[#7]

But is that customer selection affect country selection?

May you share xls file with data example and draft of chart you would like to achieve in QV?

[dmac1971]

OK lets say the data looks like this :

Customer	Item	Desc	QTY	Sales Value	Country	Region	Subregion
Customer A	1.1.1	Pan	2	100	France	Europe	Western Europe
Customer A	1.1.1	Pan	2	100	France	Europe	Western Europe
Customer B	1.1.1	Pan	1	50	Spain	Europe	Western Europe
Customer C	1.1.2	Knife	2	20	Italy	Europe	Southern Europe
Customer A	1.1.3	Cup	2	40	France	Europe	Western Europe
Customer B	1.1.5	Plate	5	150	Spain	Europe	Western Europe
Customer C	1.1.1	Pan	10	500	Italy	Europe	Southern Europe
Customer A	1.1.5	Plate	20	600	France	Europe	Western Europe
Customer C	1.1.4	Fork	25	250	Italy	Europe	Southern Europe
Customer D	1.1.3	Cup	4	80	France	Europe	Western Europe
Customer D	1.1.5	Plate	6	180	France	Europe	Western Europe
Customer D	1.1.1	Pan	11	550	France	Europe	Western Europe
Customer B	1.1.2	Knife	20	200	Spain	Europe	Western Europe
Customer A	1.1.3	Cup	10	200	France	Europe	Western Europe
Customer C	1.1.5	Plate	15	450	Italy	Europe	Southern Europe
Customer D	1.1.1	Pan	5	250	France	Europe	Western Europe
Customer D	1.1.3	Cup	50	1000	France	Europe	Western Europe
Customer C	1.1.3	Cup	60	1200	Italy	Europe	Southern Europe
Customer A	1.1.5	Plate	20	600	France	Europe	Western Europe
Customer B	1.1.2	Knife	50	500	Spain	Europe	Western Europe
Customer D	1.1.2	Knife	5	50	France	Europe	Western Europe
Customer C	1.1.1	Pan	3	150	Italy	Europe	Southern Europe
Customer A	1.1.5	Plate	3	90	France	Europe	Western Europe
Customer D	1.1.2	Knife	4	40	France	Europe	Western Europe
Customer D	1.1.3	Cup	5	100	France	Europe	Western Europe
Customer A	1.1.1	Pan	6	300	France	Europe	Western Europe
Customer B	1.1.5	Plate	5	150	Spain	Europe	Western Europe
Customer B	1.1.1	Pan	7	350	Spain	Europe	Western Europe

And my top 10 items for customer A are :

Top Items For Customer
Customer	Customer A
Row Labels	Sum of Sales   Value
1.1.5	1290
1.1.1	500
1.1.3	240
Grand   Total	2030

But for the sub region they are :

Top Items For Subregion
Subregion	Western Europe
Row Labels	Sum of Sales   Value
1.1.5	1770
1.1.1	1700
1.1.3	1420
1.1.2	790
Grand   Total	5680

So in Qlikview by selecting Customer A from a list box I have a table that shows up to top 10 items, I also want to show top 10 items for country, subregion and region.  Is this doable?

[ljackson]

This is halfway to what you want, the chart shows the sales regardless of which customer you choose.

It just needs changing a bit to show only the countries relevant to the selected customer.  Perhaps someone else could help?

.

[#10]

Like this?