table dim column data active based on button clicking

[anat]

Team,

qlikview straight  table contain data like:

country,population

IND,22

US,33

UK,44

my requirement is:

i want to create one text object or one button object,

when i click on button then country records in  straight table should be select or active.

[awhitfield]

Sorry to clarify, do you mean you want a button per country OR something else? It's not clear from your post.

Andy

[anat]

we have 1 straight table like:

year,country,sum(population)

2015,IND,22

2015,US,33

2014,UK,44

year as a dimension for selection.

when i select year 2015 = IND ,Us are possible values in country ,

now i want to create one button ,if i click on button then IND,US should be select in country .

[#4]

Hi,

From my understanding try ths:

Action on button: Select In field 

Field: country

SearchString:("IND "|"US")

Hope that helps

Regards,

Pratik

[awhitfield]

See attached example

[anat]

country data will change,i should not go for hard coded.

[awhitfield]

what about the year option? Why can't you just select the required items from a list box?

Andy

[Kushal_Chawda]

Go to Document Properties --> Triggers->

Field event Triggers -> Select Year from list of Field -> On Seelct -> Add action-> Selection ->Select Possible (Here you select country.

No need to create button. For Year 2015. automatically possible values of country will be selected