- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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..
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try renaming your field, for example region_1 ... 2 ... 3
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
hi Mario,
Could you explain further?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
For example
Load
[region] as region1,
[region] as region2;
If you like, explain your challenge a little more
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
It's okay let me review it. Will not the solution to rename the region field serve you?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
thanks it works.