topic Hide/Show based on month in QlikView

Hide/Show based on month

psk180590 — Wed, 25 Nov 2020 16:16:04 GMT

Hello All,

I believe this is a very basic thing but some how i'm not able to figure it out.

Basically, i have a text box which i would like to display only when the Month selected is less then June(Jan, Feb, Mar, Apr, May or Jun).

Even if one of these months or more then one of this(all the 6 or any number of them) is selected, the text box should be hidden.

TIA!!

sunny_talwar — Mon, 10 Jul 2017 12:45:35 GMT

May be this as a conditional hide/show expression

WildMatch(Month, 'Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun') >= 1 and GetSelectedCount(Month) = 1

stigchel — Mon, 10 Jul 2017 12:49:20 GMT

In Layout Show Condition you can use

Min(Month)<=6

Min(Month)>6

Depending on when you want to hide, month is assumed to be Loaded with e.g. Month(Date)

psk180590 — Mon, 10 Jul 2017 14:06:20 GMT

Thanks both for the quick suggestions.