Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Disable/grey out items in list box

Hello,

I have a list box for year, month and day.

When I select a year and a month, some of the days are white (possible) and some are grey (not possible).

When I select one of the grey days, I loose the selection of the year and/or month.

Is there a way to disable/grey out the days that are not possible in the list box (make them unselectable).

I know you can set 'Hide excluded', but that is not what I want.

St0ny

14 Replies
Not applicable
Author

Hello swuehl,

Thank you, this works. I tried with the chr(39), but not this variation.

Not applicable
Author

I changed the expression in the show condition of the first textbox in

Index(vDateString, Pick(8, $(vQuotedDates))) = 0

where

  vDateString: = Concat({<Date=>} Date,',')

and

  vQuotedDates: = Chr(39) & Concat({1} Date, Chr(39) & ',' & Chr(39)) & Chr(39)

How should I change the 1 in a condition independent of the Week selection and the Date selection ?

  {<Date=><Week=>}

gives an error.

swuehl
MVP
MVP

I' not quite sure I understand,

do you mean a set expression like

{<Date= , Week= >}

?

Not applicable
Author

Yes, this is what I meant.

I did not know the correct syntax.

I have changed the {1} in the vQuotedDates variable in your expression.

Not applicable
Author

Hello,

Can I use some kind of set expression to create a condition to perform a back operation ?

Something like

  = Count({1-$1 * $} Dag) > 0

an intersection between the previous excluded selection {1-$1} and the current selection {$}.

This gives me not the result I expected.