topic Re: Default selection in filter in Qlik Sense in Integration, Extension & APIs

Default selection in filter in Qlik Sense

Anonymous — Wed, 05 Oct 2016 07:08:34 GMT

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

Re: Default selection in filter in Qlik Sense

Anonymous — Mon, 10 Oct 2016 21:30:58 GMT

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

Re: Default selection in filter in Qlik Sense

Anonymous — Mon, 04 Dec 2017 09:17:19 GMT

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.

Re: Default selection in filter in Qlik Sense

shraddha_g — Mon, 04 Dec 2017 09:24:06 GMT

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

Re: Default selection in filter in Qlik Sense

Anonymous — Mon, 04 Dec 2017 09:29:03 GMT

Hi Mamta,

Thanks for the quick response.

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

Regards,

Vivek Ranawat

Re: Default selection in filter in Qlik Sense

shraddha_g — Mon, 04 Dec 2017 12:01:51 GMT

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

Is it giving value in correct Date format?

Re: Default selection in filter in Qlik Sense

Anonymous — Mon, 04 Dec 2017 14:34:07 GMT

Hi,

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

Re: Default selection in filter in Qlik Sense

Anonymous — Mon, 04 Dec 2017 14:46:47 GMT

Hi ,

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

Re: Default selection in filter in Qlik Sense

shraddha_g — Mon, 04 Dec 2017 15:00:03 GMT

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

Re: Default selection in filter in Qlik Sense

girishsrini — Thu, 22 Mar 2018 14:13:04 GMT

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.