Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
ashishtams
Contributor II
Contributor II

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

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?

1 Solution

Accepted Solutions
tresesco
MVP
MVP

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

View solution in original post

5 Replies
tresesco
MVP
MVP

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

bwisealiahmad
Partner
Partner

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.

qlik.PNG

marcus_sommer
MVP & Luminary
MVP & Luminary

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
Partner
Partner

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
Contributor III
Contributor III

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.