topic Re: restrict to select only one value at a time from straight table in QlikView

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

ashishtams — Wed, 30 Sep 2015 05:04:19 GMT

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?

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

tresB — Wed, 30 Sep 2015 07:13:53 GMT

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

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

bwisealiahmad — Wed, 30 Sep 2015 07:26:13 GMT

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.

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

marcus_sommer — Wed, 30 Sep 2015 10:55:56 GMT

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

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

Gabriel — Wed, 30 Sep 2015 11:36:51 GMT

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

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

kpradeep5610 — Tue, 20 Oct 2020 05:36:49 GMT

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.