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.

[dmac1971]

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

[#3 · Accepted solution]

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

[DavidFoster1]

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.

[#5]

Let us know if you have additional questions

regards

Darek

[dmac1971]

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

[dmac1971]

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

[#8]

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

good luck with QV

regards

Darek

[dmac1971]

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?

[DavidFoster1]

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