Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
tan_chungkam
Contributor

restrict my selection not to reflect other sheets

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..

1 Solution

Accepted Solutions
balabhaskarqlik
Honored Contributor

Re: restrict my selection not to reflect other sheets

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)

9 Replies
guitartrova
Contributor III

Re: restrict my selection not to reflect other sheets

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

tan_chungkam
Contributor

Re: restrict my selection not to reflect other sheets

hi Mario,

Could you explain further?

guitartrova
Contributor III

Re: restrict my selection not to reflect other sheets

For example

Load

[region]  as region1,

[region]  as region2;



If you like, explain your challenge a little more

tan_chungkam
Contributor

Re: restrict my selection not to reflect other sheets

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.

guitartrova
Contributor III

Re: restrict my selection not to reflect other sheets

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

tan_chungkam
Contributor

Re: restrict my selection not to reflect other sheets

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.

guitartrova
Contributor III

Re: restrict my selection not to reflect other sheets

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
Honored Contributor

Re: restrict my selection not to reflect other sheets

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
Contributor

Re: restrict my selection not to reflect other sheets

thanks it works.