topic AW:Lock one variable per sheet in QlikView

Lock one variable per sheet

Mon, 18 Oct 2010 15:14:09 GMT

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!

AW:Lock one variable per sheet

Mon, 18 Oct 2010 15:24:29 GMT

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:)

AW:Lock one variable per sheet

Mon, 18 Oct 2010 15:31:38 GMT

it works thanks!

AW:Lock one variable per sheet

johnw — Mon, 18 Oct 2010 22:55:22 GMT

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.