Lock one variable per sheet

[#1]

Hello!

I want to do the following and I was wondering how it can be done.

I have one field called region and I wanted to have one sheet per region with all the metrics

(eg one sheet called north, one called south etc)

The problem is that qlikview transfers a selection to all sheets (eg all sheets show north)

so how it would be possible to have a sheet per region ( eg north, south , west, east)

thanks!

[#2 · Accepted solution]

Hi,

my first try would be using Set analysis and a variable.

The Variable should be vRegion

Use this Variable in every Formula like sum({$<region={'$(vRegion)'}>} sales)

now go to sheet properties -> Triggers and add a OnActivateSheet - Trigger: External -> Set Variable and set the value for this sheet.

I is not very elegant but it should work.

Regards Alex:)

[#3]

it works thanks!

[johnw]

If you don't mind actually changing user selections, you can just select the value in the field itself. Same trigger spot as you're using for the variable right now. Main advantage is that it makes the expressions on the sheet simpler.