topic Re: Field value as Flag in App Development

Field value as Flag

arusiva89 — Fri, 02 Apr 2021 08:44:39 GMT

I have a field with the values x,y and z.I need to display only value "X" in checkbox (checkbox for Include X value).When it is selected,value should be associated with other objects..Any ideas/suggestions

Re: Field value as Flag

jonvitale — Mon, 07 Dec 2020 16:58:14 GMT

Can you explain more? You want to have a variable that toggles some value and then use that value in other expressions?

Re: Field value as Flag

arusiva89 — Mon, 07 Dec 2020 17:11:31 GMT

Say for example - I have a field named "List" which has values X,Y and Z.I want to have one checkbox in the sheet named "Include X Value".When I select the checkbox,value X in the field List should be selected

Re: Field value as Flag

jonvitale — Mon, 07 Dec 2020 17:46:37 GMT

If you actually want to set the value in a field (not, e.g., set the value of a variable that you then use in set analysis), you should use the "Sheet Navigation and Actions Button" that is now just called "Button" in the standard set of visualizations (November 2020). In earlier versions you can find in the "Qlik Dashboard Bundle" set of extensions.

(worst case, it is still up in Github: https://github.com/stefanwalther/sense-navigation).

You'll need to create two buttons: on the first ("left") button you'll set the action as "Set values in field" where you choose "List" as the field" and 'X' as the value. On the second ("right") button you'll set the action to "Clear values in field", for the field "List". There are some options to style by expression. You can do something like, If(Only([Field]) = 'X', style1, style2) to dynamically style the button so that it looks more like a checkbox (e.g., use a dark background if X is selected on the left button, white if it is not selected, reverse for right button).

hope that helps