Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
bbergstrom
Partner - Creator II
Partner - Creator II

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
wade12
Partner - Creator II
Partner - Creator II

qlikview = yes.

qlik sense = not that i am aware of.

View solution in original post

9 Replies
wade12
Partner - Creator II
Partner - Creator II

qlikview or qlik sense?

bbergstrom
Partner - Creator II
Partner - Creator II
Author

Sense

wade12
Partner - Creator II
Partner - Creator II

i think there may be an extension for this.

please see this link:

Default Selection in Qlik Sense

bbergstrom
Partner - Creator II
Partner - Creator II
Author

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

wade12
Partner - Creator II
Partner - Creator II

qlikview = yes.

qlik sense = not that i am aware of.

bbergstrom
Partner - Creator II
Partner - Creator II
Author

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

wade12
Partner - Creator II
Partner - Creator II

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.

bbergstrom
Partner - Creator II
Partner - Creator II
Author

Thanks Wade!

wade12
Partner - Creator II
Partner - Creator II

you're welcome brian.

best wishes.