- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
try using '=' sign before Max([Transaction Dates])
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Mamta,
Thanks for the quick response.
I tried that too adding "=" but it doesn't work.
Regards,
Vivek Ranawat
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
try to evaluate Max(Transactions dates). in KPI object..
Is it giving value in correct Date format?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
When i write in KPI object Max(Trans date) its giving correct value.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi ,
Under KPI it coming as Number when I wrote as Max(Trans Date). The result is 43070.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Use date(max(Trans Date),'Date format in Trans Date Field')
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.