topic grey filter in QlikView

grey filter

Anonymous — Sun, 25 Oct 2015 10:07:21 GMT

How can I make nov and dec in grey color ?

how can I make the dates geater than today in grey color ?

Re: grey filter

robert99 — Sun, 25 Oct 2015 10:30:14 GMT

It will automatically turn grey UNLESS you have one or more entries in the relevant table relating to this month

So I have used a white when it should really be grey to indicate an incorrect data entry. When a entry had incorrectly been given a forward date for example.

Re: grey filter

marcus_sommer — Sun, 25 Oct 2015 10:41:33 GMT

You want prevent that user could select data-areas which aren't necessarily associated with data, right? There are four different approaches possible:

- exclude those data from data-model maybe with where date < today()

- creating from an additionally flag-field to exclude such future data which are if available probably forecast-data by selecting (and locking) this field

- using of listbox-expressions as filter

- using from selection-actions which "correct" a false user-selection

The order from the above mentioned possibilities is this one which I suggest to go which is most suitable to your needs.

- Marcus