topic Re: How to restrict dimension value selection in Straight table? in QlikView

How to restrict dimension value selection in Straight table?

punitpopli — Fri, 26 Jun 2015 11:19:46 GMT

Hi All,

In my attached dummy application I have two sheets, first is the summary sheet while other is detail sheet.

I have to navigate to the detail sheet on click on the District name in the straight table on summary sheet, this I have achieved through filed level trigger (Field level trigger under document properties)

Now, my actual requirement is to restrict the district value to one and only one when I move to detail sheet by selecting a district from the straight table on summary sheet.

e.g. : If I select ALBANY district on the summary sheet then it will moved to detail sheet with selected district as ALBANY.

Is there a way to restrict user to select only one district as in current scenario we can select multiples district.

Please let me know your inputs on the same

Thanks in advance

Punit

Re: How to restrict dimension value selection in Straight table?

tresB — Fri, 26 Jun 2015 11:31:52 GMT

If this selection restriction is not specific to sheet, you could use 'Always One Selected Value' in list box (select one value from the list, then listbox - general tab, check that option)

Re: How to restrict dimension value selection in Straight table?

giakoum — Fri, 26 Jun 2015 11:38:52 GMT

adding to tresesco, it could be a duplicate field that you set as "Always one selected" but in a different state so that it does not affect your summary sheet. And the user should use the duplicate field to select and automatically be moved to details. You need to change the details view to the new state as well.

But I would simply add the district dimension in the details view and a disclaimer stating that more than one district is selected. Transfer the responsibility to the user to make only one selection. No complicated triggers and states this way. Plain old standard QlikView functionality.

Re: How to restrict dimension value selection in Straight table?

Kushal_Chawda — Fri, 26 Jun 2015 11:41:40 GMT

Yes, you can do something like this. Just change the condition of Field event trigger and use error msg to restrict selection to only one

Re: How to restrict dimension value selection in Straight table?

punitpopli — Fri, 26 Jun 2015 11:55:04 GMT

Hi kush14101987‌,

Thank for you reply, I was also tried the same. but i was actually looking for a way in the straight table similar to what we have in list box(i.e. one value selected ) as tresesco‌ has suggested in above.

Thanks,

Punit

Re: How to restrict dimension value selection in Straight table?

Kushal_Chawda — Fri, 26 Jun 2015 11:58:37 GMT

So what I understood is you want to select the value from straight table from summary tab?

Re: How to restrict dimension value selection in Straight table?

punitpopli — Fri, 26 Jun 2015 12:21:02 GMT

Hi kush14101987‌,

Yes only ONE value should get selected from summary tab , not more than one.

The same value will pass to other sheet as a parameter and details of that district will get displayed in the detail sheet

Re: How to restrict dimension value selection in Straight table?

Kushal_Chawda — Fri, 26 Jun 2015 12:38:10 GMT

I think what i have attached is doing the same.. have you checked my attachment?

Re: How to restrict dimension value selection in Straight table?

Kushal_Chawda — Fri, 26 Jun 2015 13:12:10 GMT

In my application if you select multiple values from staight table it will display error msg which will say you can select only one values