topic Re: Set Selection field with Alternate States in QlikView

Set Selection field with Alternate States

Mon, 09 Jun 2014 07:05:02 GMT

Hi,

When I click on some field on my straight table, for example "Name", I want the "Name" field with Alternate State called "StateA" will be filtered too - using triggers. But I don't know the right syntax for this...

And I want to to the opposite case.

When I choose some value from the "Name" field on the Multi-Box with Alternate State "StateA" I want the same value on the Field "Name" without any Alternate State will be seleceted.

Thanks in advance!

Re: Set Selection field with Alternate States

tresB — Mon, 09 Jun 2014 07:07:03 GMT

Try to create a sample qvw and share

Re: Set Selection field with Alternate States

CELAMBARASAN — Mon, 09 Jun 2014 07:19:32 GMT

Could you explain the scenario that you are going to implement? There might be some other better way to do this.

Re: Set Selection field with Alternate States

alexandros17 — Mon, 09 Jun 2014 07:34:51 GMT

If you need that an expression is influenced by set analysis, the syntax is

Sum({STATE1 <quarter={'Q1'}>} week)

where:

I used sum but you can use any aggregation function

STATE1 is the alternate state used in the list box (or multibox) to select values

quarter={'Q1'} is a condition (but you can omit it writing only: Sum({STATE1} week)

Let me know

Re: Set Selection field with Alternate States

Mon, 09 Jun 2014 07:39:50 GMT

Thanks guys,

I found my solution.

When I define some new alternate state, the selection box with the wanted alternate state is shown near the text fields at the triggers window.

Thanks for your help!