Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Lock one variable per sheet

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!

1 Solution

Accepted Solutions
Not applicable
Author

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

View solution in original post

3 Replies
Not applicable
Author

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

View solution in original post

Not applicable
Author

it works thanks!

johnw
MVP
MVP

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.