restrict to select only one value at a time from straight table

[ashishtams]

Hi All,

I want to know if its possible  to restrict the selection of values in the straight table to only one value at a time.

I have a dependency on the value selection and if multiple values are selected the data does not look good. So I want to restrict the selection to only one value at a time.

If possible how can this be done?

[tresesco · Accepted solution]

List box ->Select a value->Right click->Properties->General tab-> Check 'Always One Selected Value'   ?

[bwisealiahmad]

Hi,

Unless it is what Tresesco points out above it could also be under Straight Tables and on the "Dimension Limits" tab. Here you can pick "Restrict Values" and then Show Only -> First/Largest/Smallest -> 1 values (Remember to remove "Show others" lower down.

[marcus_sommer]

Beside the suggestion from tresesco which effects the selection from this field global you could use calculation-conditions within this table like: getselectedcount(YourField) = 1. A further possibility might be to adjust your expressions maybe with set analysis.

- Marcus

[Gabriel]

Hi,

What I think you can do is in the Straight chart

General Tab -> In Calculation Condition, type below expression.

     =IF(GetSelectedCount(DimensionFieldName)>1,0,1)

Then in the Error Messages Select condition unfulfilled then expression will be

=IF(GetSelectedCount(DimensionFieldName)>1 ,'Please select one value at anytime')

This will give user instruction what to do.

Try it and let us know what you think

Hope this helps

[kpradeep5610]

Hi Tresesco,

I want to do the same thing in Field Filter in QLIK SENSE Enterprise, could you please how to do it in qlik sense.