topic Re: Retain a Selection in a Sheet when you switch back in QlikView

Retain a Selection in a Sheet when you switch back

prathipsrinivas — Sun, 23 Sep 2018 11:53:59 GMT

Hey Folks,

I have a requirement in which I want to retain a selection that I made in a Sheet when I switch to other Sheet/tab, when I come back to the Original Sheet where I made that Selection, that should be there irrespective of selections that I made in other page.

I have two buttons to switch between the Sheets, I have tried writing actions using on Getfieldselections(fieldname).

The thing is when I select single value in the other sheet , it works fine. When I select multiple values in the other sheet and I switch back, field will be cleared with no selection. Here, I want to have the previously selected value when I selected in the sheet.

Could you guys help me to implement on this.

Re: Retain a Selection in a Sheet when you switch back

swuehl — Sun, 23 Sep 2018 12:35:09 GMT

You can use alternate states in each sheets to separate the selections made in each sheet from affecting other sheets.

http://www.qlikfix.com/2014/08/12/alternate-states/

Or use sheet event triggers to store / replace and call a bookmark when leaving / entering a sheet.

Re: Retain a Selection in a Sheet when you switch back

prathipsrinivas — Mon, 08 Oct 2018 07:48:26 GMT

Hi Stefan,

I have achieved it using Variables.

Thanks,

Prathip