Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
shree909
Partner - Specialist II
Partner - Specialist II

How to make listbox values as readonly in qliksense

Hi

I have a scenario where i want to display a listbox with no selections.

I know in qlikview if you enable the condition as readonly on listbox, it will not allow to make any selections.

Is there something we do in qliksense

3 Replies
Gysbert_Wassenaar

You can try using a Text & image object with an expression that returns a list of the items. Something like =concat(distinct MyField, chr(10))


talk is cheap, supply exceeds demand
shree909
Partner - Specialist II
Partner - Specialist II
Author

Thanks Gysbert that worked.

But i have a long list then i wont  see the scroll bar when i reduce the size.

AustinSpivey
Partner - Creator
Partner - Creator

This is an old post but one of the ways you can achieve this, though a bit janky, is to use the ValueList() function to create a synthetic dimension that cannot be selected. As an example, here's an expression you can use in a filterpane to show the values in the [Dim2] field while keeping users from being able to select those values:

=ValueList('$(=Concat(all distinct [Dim2], ''','''))')

The ValueList() function takes a list of strings as the values for the synthetic dimension, so we use the Concat() function to combine the values of the [Dim2] field and separate them with a single quote, comma, and then another single quote, and then all of that is used inside of an outer set of single quotes and accessed using dollar-sign expansion. Basically we're generating a separate string for each distinct [Dim2] value.

In Qlik Cloud and the most recent releases of Qlik Sense Enterprise Client Managed, you can take this a step further by changing the color of the filterpane's selected state to be white so that even if users try to select those value, they will not show a green color, reducing possible confusion:

AustinSpivey_0-1701367087744.png

 

Austin Spivey | Principal Consultant @ Arc Analytics
ArcAnalytics.us | Add me on LinkedIn