topic Re: Get Current Selections? in QlikView

Get Current Selections?

dmac1971 — Mon, 31 Mar 2014 11:45:58 GMT

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.

Re: Get Current Selections?

MK_QSL — Mon, 31 Mar 2014 11:49:36 GMT

Kindly describe briefly or more specifically your requirements...

Dont understand properly.

Re: Get Current Selections?

Mon, 31 Mar 2014 11:52:52 GMT

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

Re: Get Current Selections?

dmac1971 — Mon, 31 Mar 2014 11:57:23 GMT

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.

Re: Get Current Selections?

Mon, 31 Mar 2014 12:37:34 GMT

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

Re: Get Current Selections?

dmac1971 — Mon, 31 Mar 2014 12:40:23 GMT

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.

Re: Get Current Selections?

Mon, 31 Mar 2014 12:46:50 GMT

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?

Re: Get Current Selections?

dmac1971 — Mon, 31 Mar 2014 12:59:18 GMT

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?

Re: Re: Get Current Selections?

ljackson — Mon, 31 Mar 2014 13:01:55 GMT

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?

Re: Re: Get Current Selections?

Mon, 31 Mar 2014 13:23:34 GMT

Like this?

Re: Get Current Selections?

dmac1971 — Mon, 31 Mar 2014 13:40:28 GMT

Yes this is the direction I want to go. Can you explain what the P does? Is it a system variable?

Re: Get Current Selections?

Mon, 31 Mar 2014 13:47:17 GMT

Find in your Help: Set Analysis.

There are also many additional documents and informations on the forum

P() gives possible values

E() gives excluded values

regards

Darek

Re: Get Current Selections?

DavidFoster1 — Mon, 31 Mar 2014 13:57:46 GMT

A slight alternative to the solution Dariusz Mielczarek provided you is to disregard the customer selection using <Customer=> so that your report is filtered just be the sub region and above.

Re: Get Current Selections?

Mon, 31 Mar 2014 14:06:59 GMT

Let us know if you have additional questions

regards

Darek

Re: Get Current Selections?

dmac1971 — Mon, 31 Mar 2014 14:09:06 GMT

Thanks guys, still learning as you can see. I have 2 days formal training coming up which should cement my knowledge so far!!!

Re: Get Current Selections?

dmac1971 — Mon, 31 Mar 2014 14:19:58 GMT

Thanks guys was able to figure the rest out. Much appreciated!!!

Re: Get Current Selections?

Mon, 31 Mar 2014 14:27:32 GMT

Here is very good book, you may like: http://www.packtpub.com/qlikview-11-developers/book

good luck with QV

regards

Darek

Re: Get Current Selections?

dmac1971 — Mon, 31 Mar 2014 14:46:46 GMT

But now have another question. I'd like to generate a heading on the fly, ie use a text item and the following.

="Top 10 Items for " & GetFieldSelections(Customer)

Is there an easy way to return the Region, Subregion etc the same way?

Re: Get Current Selections?

DavidFoster1 — Mon, 31 Mar 2014 15:01:50 GMT

Look at the CONCAT function. Be careful because you can end up with very long labels.