Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Highlighted
Partner
Partner

Setting Filter Values Based on Variables

So, I have a sheet where I want the visuals to only show values for the past month unless a user enters a date in a filter field.  I am currently handling this now via set analysis but I have to do this for every measure and it seems to be affecting performance.  What I am looking for is a way to set values in a filter pane based on a couple of variables I have in the loadscript. 

Filter Pane - Transaction Date (data contains the last 4 years)

vStartDate = '09/17/2018'

vEndDate  = '10/16/2018'

What I would like is to have all of the dates between 09/17/2018 and 10/16/2018 selected in the filter pane by default when the user enters the sheet.

Any help is appreciated. 

1 Solution

Accepted Solutions
Partner
Partner

Re: Setting Filter Values Based on Variables

qlikview = yes.

qlik sense = not that i am aware of.

9 Replies
Partner
Partner

Re: Setting Filter Values Based on Variables

qlikview or qlik sense?

Partner
Partner

Re: Setting Filter Values Based on Variables

Sense

Partner
Partner

Re: Setting Filter Values Based on Variables

i think there may be an extension for this.

please see this link:

Default Selection in Qlik Sense

Partner
Partner

Re: Setting Filter Values Based on Variables

So no out of the box solution with the standard filter panes?

Partner
Partner

Re: Setting Filter Values Based on Variables

qlikview = yes.

qlik sense = not that i am aware of.

Partner
Partner

Re: Setting Filter Values Based on Variables

That is what I was afraid of.  Is there any place to request features?

Partner
Partner

Re: Setting Filter Values Based on Variables

Qlik have the Qlik Beta Programs area where they make different beta releases available to Qlik customers and partners, ask them to try them out and collect their feedback.

You can also take a look at the Qlik Product Insight space where Qlik publish product surveys on different topics and ask customers and partners to give them feedback.

In addition, Qlik have the Product Validation program in place. If you want to have more impact on product direction, join the validation program in your area. For more details please email the Validation Manager for EMEA Mark Philips.

Partner
Partner

Re: Setting Filter Values Based on Variables

Thanks Wade!

Partner
Partner

Re: Setting Filter Values Based on Variables

you're welcome brian.

best wishes.