topic How to get values according to selected listbox value. in QlikView

How to get values according to selected listbox value.

Sun, 23 May 2010 20:13:45 GMT

Hi All,

I have 1list box named Continent and one column country ,at the sheet level.

As per the requirement I need to write a code so that i can get the following output in a textbox as a heading:

Continent Asia has countries: India,Pakistan,China...... (all the countries should be displayed accordin to continent).

Please tell me what code i need to write and when to call this code.

It is very urgent. Help me on this.

Thanks in advance

rwunderlich — Mon, 24 May 2010 04:03:55 GMT

Do you only want to display when a single Continent is possible? If so then:

=if(GetPossibleCount(Continent) = 1, 'Continent ' & Continent & ' has countries: ' & concat(Country, ', '))

-Rob

Mon, 24 May 2010 14:10:42 GMT

Thank you so much Rob for the reply.

One issue is coming that is like Country is not primary key. So i am getting repeated country how can we resolve it ?

Thanks in advance.

boorgura — Mon, 24 May 2010 15:14:59 GMT

You can use concat(DISTINCT <>)

Let me know if it resolves your issue.

Mon, 24 May 2010 15:29:04 GMT

Thanks Rocky ... it is working.