topic Re: Check if item is disabled or enabled in QlikView

Check if item is disabled or enabled

danosoft — Fri, 13 Jan 2023 16:39:51 GMT

This is the situation: when i enter in my sheet, I have an action that selects the writing CRE, consequently I would like to select the year 2023 but for CRE the year 2023 is not selectable becouse without data..... there is a way to test that in the YEAR field the value 2023 is NOT selectable and so I automatically select 2022?

Thanks

Re: Check if item is disabled or enabled

rubenmarin — Sat, 14 Jan 2023 11:06:56 GMT

Hi, one you have CRE selected, the next action can just select the value =Max(YEAR).

Besides that the check could be the same: If(Max(Year)<2023, '2023 not selectable', '2023 selectable)

or: If(Max({<FieldName={'CRE'}>}Year)<2023, '2023 not selectable', '2023 selectable)

Re: Check if item is disabled or enabled

danosoft — Mon, 16 Jan 2023 09:30:30 GMT

Thanks you but if i put the 2 soluntions i have an error: Error in expression: ')' expected

Re: Check if item is disabled or enabled

rubenmarin — Mon, 16 Jan 2023 09:32:05 GMT

Hi, I missed a simple quote after selectable in both options:

If(Max({<FieldName={'CRE'}>}Year)<2023, '2023 not selectable', '2023 selectable')

Re: Check if item is disabled or enabled

danosoft — Mon, 16 Jan 2023 14:37:09 GMT

Thanks you, but the problem is..... if i put the Max(YEAR) in a text box after i choice CRE is say me right solution 2022, but if i put like an ACTION in the open Sheet.... it choose 2023 and not 2022... why??

and i need choice that opening my sheet so in the action

Re: Check if item is disabled or enabled

rubenmarin — Mon, 16 Jan 2023 14:54:37 GMT

Try with Max({<FieldName={'CRE'}>}Year).

Instead of 'FieldName' use the name of the field where CRE is selected.

Re: Check if item is disabled or enabled

danosoft — Mon, 16 Jan 2023 15:41:18 GMT

I accept as the solution, thanks... it have only a problem, it work always except the first time i go in the sheet (but strange becouse the text box where i show the value it say me the correct value 2022).... all the others times it work

Re: Check if item is disabled or enabled

rubenmarin — Mon, 16 Jan 2023 16:36:13 GMT

Maybe the sheet has other actions, or there are another actions set, or macros that changes the value the first time is open.

Also I see in the image that it shows the YEAR field with a red line, meaning that there is no field with that name, maybe that what's failing in the previous post.

Re: Check if item is disabled or enabled

danosoft — Mon, 16 Jan 2023 16:40:04 GMT

nono, that only becouse i traslate in english the field for this post, becouse my field name is in italian ANNO