Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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!
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;}
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
That seems like excactly what I am looking for. To bad that is not available in my version
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.
That release will be end-of-support in August of this year, so maybe you can get an upgrade 🙂
-Rob