Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

yangcelinexu
Contributor

Could i Set Pre filter for one Sheet in the App?

Hi,

I have an datasets have 100+ supplier.  will product sold info.

I have a first page as overall analysis

want to have sheet 2 only focus one 1 single supplier.

Now I use Supplier filter to filter the supplier. as follow.

Screen Shot 2017-10-30 at 15.17.10.png

But any chance I can set up a 'hidden fix' filter for this second sheet to limited all the content is only related to this supplier or I need to create a dataset first only limited to this supplier?

Regards,

Tags (1)
1 Solution

Accepted Solutions
OmarBenSalem
Esteemed Contributor

Re: Could i Set Pre filter for one Sheet in the App?

You have a bunch of extensions that could help you achieve this:

take a look at this :

http://branch.qlik.com/#!/project/590e0d8475aa3cff35e4f61b

4 Replies
OmarBenSalem
Esteemed Contributor

Re: Could i Set Pre filter for one Sheet in the App?

You have a bunch of extensions that could help you achieve this:

take a look at this :

http://branch.qlik.com/#!/project/590e0d8475aa3cff35e4f61b

rittermd
Honored Contributor

Re: Could i Set Pre filter for one Sheet in the App?

You would need to use an extension or possibly create a bookmark.  But I don't think that there is a way to force the bookmark when the user opens the app. 

OmarBenSalem
Esteemed Contributor

Re: Could i Set Pre filter for one Sheet in the App?

You can also refer to this:

Default Selection in Qlik Sense

Re: Could i Set Pre filter for one Sheet in the App?

Hi,

You can use the set analysis to restrict chart to show data for only one or more values of a field.

Say example if you want to always show year 2010 data then your expression will be.

Sum({<Year = {"2010"}>}Sales)

Regards,

Kaushik Solanki

Community Browser