Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
napac1458
Contributor II

Use trigger to set selections in an alternate state

Hello everyone,

I have users making selections in other sheets, but when they open up a particular tab (which is in a alternate state), the location should be set to the location they selected for the other sheets.

Is it possible to set selections within an alternate state using a trigger?

Alternatively, can I avoid using an alternate state completely and just have a listbox ignore other selections?

Thank you in advance!

2 Replies
micheledenardi
Valued Contributor

Re: Use trigger to set selections in an alternate state

Hi David,

In your objects in the alternate state sheet change your expression and use set analysis like:

sum({Group1} <Location=$::Location> Sales)

Legend:

{Group1}: the expression refer to Group1 alternate state selection.

Location=$::Location: for the "Location" field, the expression consider the "default state" of your document (so the state for the other sheets).

vishsaggi
Esteemed Contributor III

Re: Use trigger to set selections in an alternate state

Can you share somemore information and expected output with some sample data. We might be able to take off Alternate States and Ignore selections using set analysis. I cant assume unless i can see some expected output.