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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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.