Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Zurich on Sept 24th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
oddgeir
Contributor III
Contributor III

One click filter? (Like dynamic set of buttons)

Hi

Is it possible to make the filter pane act like a dynamic set of buttons?

If there is no current solution to this, it is a suggestion to Qlik which should be relatively easy to implement. 

Details: 
As far as I have seen there is no way to tell the filter pane to have single choice and one click. We had a set of buttons initially, because there was a few primary choices. However this doesn't scale, Updating buttons requires a lot of clicking, copying and pasting, and there is a risk to forget one of the updates (either the value chosen or the text shown on the button). 

My first assumption was that filter pane should solve this, but it seems this will require two clicks to make a choice. It doesn't seem much but it is double amount of clicks for what is the normal start for most people, so it affects usability in a very core area. 

My suggestion is to extend filter pane with a new selection: "Button set", which simply drops the "lock/cancel"-function. A sub set of this could be "single choice" or "toggle". 
The filter pane already works like button set with toggle if I simply ignore the final confirmation, so it shouldn't be too hard to make this work. 

Labels (2)
6 Replies
diegozecchini
Specialist
Specialist

Hi
we can create buttons in Qlik that apply selections to a field. These buttons can be styled and customized to look like a "button set." However, as you noted, this approach isn't scalable for large datasets or dynamically changing values because updating the buttons manually is time-consuming and error-prone.

I think your suggestion is both relevant and practical for improving usability in Qlik!

premacharya0903
Contributor II
Contributor II

Hi @oddgeir  , 

You can try the workaround using the variable input  and some basic css stylying .

- Create a variable using the variable editor  or load script - (vDimValue )

- Create a variable input object in the sheet , with variable as vDimValue , 'show as dropdown' and  the values as dynamic .

- use  concat({1}distinct [Field1],' |',[Field1]) to get the values dynamically assigned to the variable input. This would give you all distinct values for Field1 as dropdown.

- Update the expression to filter the data set : sum({<Field1 ={'$(vDimValue)'}>} Income) 

As the variable values are dynamic , this would work with your data reduction as well . 

css for styling, can be customised.

.qv-object-qlik-variable-input .qv-inner-object
{
background-color : transparent !important;
flex-direction: row;
padding: 0px;
}
.qv-object-qlik-variable-input .qv-inner-object .lui-select
{color: #ffffff;
background-color: #253038;}

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

I believe the single click option is already available when you uncheck "Show selection toolbar" in the Listbox properties. 

 

-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com

rwunderlich_0-1737659286416.png

 

oddgeir
Contributor III
Contributor III
Author

That seems like excactly what I am looking for. To bad that is not available in my version

oddgeir_1-1737701973308.png

 

oddgeir_0-1737701837150.png

 

oddgeir
Contributor III
Contributor III
Author

Thank you for your suggestion. I'll try to get time to look into this solution some time soon, and se if this solves my way. Right now I just wanted to share what I believe is lack of ways to do this an easy way, and for this time I guess the cost/benefit favours just doing the manual update.

If I understand your approach correctly this requires me to update all relevant expressions to use alternate set. I'm not sure updating all expressions on all my pages lowers neither effort nor risk. My mail objective was to scale single click selections in a neat and tidy way. By introducing variables, alternate sets and css styling it seems to add some complexity to the matter. I'm not saying it's not a possible way, just that it requires a bit more than a feature selection. 

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

That release will be end-of-support in August of this year, so maybe you can get an upgrade 🙂

-Rob