restrict my selection not to reflect other sheets

[tan_chungkam]

Hi all,

This is Qliksense.

I have a region filter pane in every sheets.

I would like to restrict my selection not to reflect other sheets.

Every sheets should have their own selection.

Is there anyways to do that?

Please find attached my qvf file.

Thanks..

[MarioCenteno]

Try renaming your field, for example region_1 ... 2 ... 3

[tan_chungkam]

hi Mario,

Could you explain further?

[MarioCenteno]

For example

Load

[region]  as region1,

[region]  as region2;

If you like, explain your challenge a little more

[tan_chungkam]

thanks for your reply.

I would appreciate if you could have a look in my qvf file.

It is load from an excel file which has 2 sheets - Asia and Europe.

And i have to create 2 sheets in the app.

One sheet only show Asia figure.

and another sheet only show Europe figure.

Thanks a million.

[MarioCenteno]

It's okay let me review it. Will not the solution to rename the region field serve you?

[tan_chungkam]

It works but at the end i have to create another sheet (total) which show sum of the figure from asia and europe.

The figure does not look right at it.

[MarioCenteno]

Try

Give one state to all the objects Sheet1 and another state to all the objects in Sheet2.

Here is the extension link.

http://branch.qlik.com/#!/project/5693cd6715f524dc43e7ec37

Also check the video on how to use the extension.

Qlik Sense Alternate States - The Full Set - YouTube

[balabhaskarqlik · Accepted solution]

Try expressions like this:

In script, create additional script pertains Countries list of different zones (Asia, Europe), then in UI

In 1st Sheet

Sales Asia: Sum({$<SalesTerritoryCountry=P([Sales Asia Countries])>}Sales)

In 2nd sheet:

Sales Europe: Sum({$<SalesTerritoryCountry=P([Sales Europe Countries])>}Sales)

[tan_chungkam]

thanks it works.