Qlik Community

Qlik Sense Integration, Extensions, & APIs

Discussion board where members can learn more about Integration, Extensions and API’s for Qlik Sense.

mamgang08
New Contributor

Default selection in filter in Qlik Sense

I am building a report in Qlik Sense, I want a default value to be always selected in filters. How to implement that.

1 Solution

Accepted Solutions
kencbowman
New Contributor II

Re: Default selection in filter in Qlik Sense

Hi Mamta,

I had luck with the Climber Selection Bar extension. You select "Field" for the List type parameter, your dimension for the Field parameter and set your function for the Initial selection parameter (both setting a static string and using the max function on a dimension worked for me). You can also hide the "list" by unchecking the Visible checkbox.

This worked best for me by placing a couple of these on a separate sheet (e.g. the first sheet that the user should click on).

hth,

Ken

9 Replies
kencbowman
New Contributor II

Re: Default selection in filter in Qlik Sense

Hi Mamta,

I had luck with the Climber Selection Bar extension. You select "Field" for the List type parameter, your dimension for the Field parameter and set your function for the Initial selection parameter (both setting a static string and using the max function on a dimension worked for me). You can also hide the "list" by unchecking the Visible checkbox.

This worked best for me by placing a couple of these on a separate sheet (e.g. the first sheet that the user should click on).

hth,

Ken

vivekranawat
New Contributor II

Re: Default selection in filter in Qlik Sense

Hi,

Can you please share the screenshot for the same or it would be great if you can help me to resolve the below query.

What I was trying to do is. In List type, i added the Transaction dates and in the Initial selection, i was mentioning Max(Transactions dates). But it doesn't work.

shraddha_g
Honored Contributor III

Re: Default selection in filter in Qlik Sense

try using '=' sign before Max([Transaction Dates])

vivekranawat
New Contributor II

Re: Default selection in filter in Qlik Sense

Hi Mamta,

Thanks for the quick response.

I tried that too adding "=" but it doesn't work.

Regards,

Vivek Ranawat

shraddha_g
Honored Contributor III

Re: Default selection in filter in Qlik Sense

try to evaluate Max(Transactions dates). in KPI object..

Is it giving value in correct Date format?

vivekranawat
New Contributor II

Re: Default selection in filter in Qlik Sense

Hi,

When i write in KPI object Max(Trans date) its giving correct value.

vivekranawat
New Contributor II

Re: Default selection in filter in Qlik Sense

Hi ,

Under KPI it coming as Number when I wrote as Max(Trans Date). The result is 43070.

shraddha_g
Honored Contributor III

Re: Default selection in filter in Qlik Sense

Use date(max(Trans Date),'Date format in Trans Date Field')

girishsrini
New Contributor III

Re: Default selection in filter in Qlik Sense

Hi Ken,

Greetings.

This extension is just fantastic and serve the purpose. However, because its not certified by Qlik yet, our customer is reluctant go with this. How was implementation of this extension in your Apps and was there any potential virus or loopholes issues.

Community Browser