topic Re: Filter list box which influence for every object with different alternate states in QlikView

Filter list box which influence for every object with different alternate states

Anonymous — Mon, 23 Nov 2015 13:18:51 GMT

Good day!

In my model i have several object with different states. (State1,State2, State3,State4,State5)

I need to add some list box with some filters (For example, month), which must filter data in all objects with such states.

Is it possible?

Thanks.

Re: Filter list box which influence for every object with different alternate states

sunny_talwar — Mon, 23 Nov 2015 13:23:34 GMT

You can configure your expressions to react to inherited state's list box. But this would require you to change the expression within all the objects, not really sure if you would like to do that.

Re: Filter list box which influence for every object with different alternate states

Anonymous — Mon, 23 Nov 2015 13:31:58 GMT

Could you please write some example (come expression), which will react to inherited state's in listbox?

I think, it must be some special operator in expr?

Thanks.

Re: Filter list box which influence for every object with different alternate states

sunny_talwar — Mon, 23 Nov 2015 13:35:33 GMT

So lets say your chart is in state2 and you want it to react to a field in inherited state called Field1

Sum({<Field1 = $::Field1>} Sales)

The above expression will react to all selections in state2 + it will react to selection in Field1 from inherited state now

Re: Filter list box which influence for every object with different alternate states

t_chetirbok — Mon, 23 Nov 2015 14:09:13 GMT

Hi!

Your list box should be in inherited state

and in chart you can use expression for example: sum( {$*State1} SALES)

Re: Filter list box which influence for every object with different alternate states

Anonymous — Mon, 23 Nov 2015 14:18:30 GMT

Perfect!

Thanks!!!!