topic Re: Alternate States query in QlikView

Alternate States query

hopkinsc — Wed, 24 Jun 2015 08:59:24 GMT

Hi all,

can anyone tell me how i can pass a selection from 1 list box on a sheet (inherited state) to another list box on another sheet (in state2).

I have attached an example.

in the example i have 2 alternate states, ignore State1 as this is used on another part of the qvw.

Thanks

Re: Alternate States query

sgrice — Wed, 24 Jun 2015 09:01:18 GMT

Use a Macro to Select in Field using a Concatenation from one state and apply the select in field to the other STATE.

Re: Alternate States query

vardhancse — Wed, 24 Jun 2015 09:01:33 GMT

create one alternate state.

documents and settings->alternate state->New state

for what ever objects we want we can give the alternate state.

Object properties->General->Alternate state

So of 2 objects are having one single alternate state, either they may be there in different sheets the selections will pass only to those 2 objects

Re: Alternate States query

hopkinsc — Wed, 24 Jun 2015 09:10:36 GMT

hi, i dont want to use a macro as i believe this can be done using triggers.

also, both objects need to stay in their current states (on sheet 1 inherited, on sheet 2 state2) this is because if i place them both in the same state then other objects on those sheets wont respond to them.

I need all objects on sheet 1 to continue responding to the selections made in the list box and all objects on sheet 2 to respond to the selections from the list box on sheet 2

Does that make more sense?

Re: Alternate States query

vardhancse — Wed, 24 Jun 2015 09:13:35 GMT

Hi so you are looking for

Sheet 1 and one object from sheet 2 need to modify based on the selections in sheet 1

Sheet 1:

entire sheet->Alternate state->state1

sheet 2:

Only one object->Alternate state->state1

Re: Alternate States query

hopkinsc — Wed, 24 Jun 2015 09:17:45 GMT

No, sheet 1 stays as default state (all objects).

Sheet 2 is state 2 (all objects)

but i want to carry selections from the list box on sheet 1 over to the same list box on sheet 2.

if i set the 2 list boxes up in their own state then the other objects on the same sheets will not respond to the selections.

i just want to be able to set a trigger so when i move to sheet 2 i carry the selections over from the list box on sheet 1

Re: Alternate States query

vardhancse — Wed, 24 Jun 2015 09:20:57 GMT

Sorry I can't get you, by default the selections will pass to all sheets right.?

more over if we assign state1 alternate state to sheet 1, so what ever selections we done in sheet 1 list box will reflect in only in sheet1 and if we assign staate 1 alternate state in sheet 2 list box then this list box also the selections will pass.

Re: Alternate States query

sgrice — Wed, 24 Jun 2015 09:26:00 GMT

You can just achieve this by using set analysis in the charts that you want to react to both

Using

Sum({MyFirstState <Year=MySecondState::Year>} SALES)

Re: Alternate States query

hopkinsc — Wed, 24 Jun 2015 09:27:32 GMT

hi, the selections will only pass if they are in the same state.

sheet 2 will be in a different state.

I want sheet 1 to be in the default state

Sheet 2 to be in state 2

so no selections will pass across in this setup.

so i want to override that by passing the selections from a single list box on sheet 1 (that is in the default state) to the same list box on sheet 2 (that is in state 2)

i think i need to use a getfieldselections and a concat maybe into a variable then use a select in field trigger on sheet 2 to pass the variable contents to the list box in state 2. but i dont know the syntax to use.

Re: Alternate States query

hopkinsc — Wed, 24 Jun 2015 09:28:55 GMT

Hi Steve,

Thanks for your reply. but that means changing every expression in every chart on that sheet.

surely there is an easier way?

Re: Alternate States query

hopkinsc — Wed, 24 Jun 2015 09:58:50 GMT

Hi all,

for anyone else who needs to do this i have managed to get it working using an on activate sheet trigger.

see attached sample

Re: Alternate States query

sgrice — Wed, 24 Jun 2015 10:01:18 GMT

Then you are back to

Then use a Trigger with action

Select in Field

myField

=concat({myFromState}distinct '"'&myField&'"' , '|') & ')'

Remember to change the STATE of the action to the state you want it to effect.

set the trigger on the TAB open Trigger.