topic list box in QlikView

list box

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

HI All ,

i have two tabs one is main tab which has bar charts and line charts in it is related to sales data

and the other tab is Deatail this tab has information about employees and sales details too .

now in the Detai tab i use a filter called

"Plus" within which the content is like "Level One" and this filter "Plus " i used as a filter when i click on Level one , all the Detail tab show the sales related to only Level One employee

and when click on Main tab there also the values change according to the selection of Level one , where as i have not used Plus list box here .

My rewuirement is like

Whenever i Navigate to Main tab , the plus filter (Level One ) should get deselected .. can i achieve this ?

Thanks in advance

Re: list box

punitpopli — Mon, 17 Apr 2017 04:39:30 GMT

You can use select in field in Sheet event trigger and place a list box on the sheet for testing and can hide later.

How this will work :

Goto sheet properties
Triggers
OnActivateSheet
Select - Select in field
In the Field use Plus filter
In Search String enter level one and
click on apply
Save

Hope this will solve your req.

Re: list box

smilingjohn — Mon, 17 Apr 2017 05:05:23 GMT

But i want to clear the field Plus .... i think u posted the above procedure to make selections ....

Re: list box

Anonymous — Mon, 17 Apr 2017 05:12:03 GMT

HI John,

You can use alter state property,it may help you to meet ur requirement.

find the attachment.

R/Murali.

Re: list box

punitpopli — Mon, 17 Apr 2017 06:07:37 GMT

first three steps can be used as it is and instead of "Select in Field " you can use "Clear field" action

Re: list box

avinashelite — Mon, 17 Apr 2017 06:38:16 GMT

In the Sheet level triggers we have option to select and deselect a filed ..go to sheet properties > Triggers > On Activate > Select the option to clear the field and mention the filed to clear