topic Re: table dim column data active based on button clicking in QlikView

table dim column data active based on button clicking

anat — Fri, 20 Nov 2020 18:02:30 GMT

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.

Re: table dim column data active based on button clicking

awhitfield — Thu, 30 Jul 2015 13:10:29 GMT

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

Andy

Re: table dim column data active based on button clicking

anat — Thu, 30 Jul 2015 13:19:10 GMT

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 .

Re: table dim column data active based on button clicking

Thu, 30 Jul 2015 13:28:40 GMT

Hi,

From my understanding try ths:

Action on button: Select In field

Field: country

SearchString:("IND "|"US")

Hope that helps

Regards,

Pratik

Re: table dim column data active based on button clicking

awhitfield — Thu, 30 Jul 2015 13:31:51 GMT

See attached example

Re: table dim column data active based on button clicking

anat — Thu, 30 Jul 2015 13:33:37 GMT

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

Re: table dim column data active based on button clicking

awhitfield — Thu, 30 Jul 2015 14:16:18 GMT

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

Andy

Re: table dim column data active based on button clicking

Kushal_Chawda — Thu, 30 Jul 2015 14:32:12 GMT

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