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

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
psk180590
Creator III
Creator III

Hide/Show based on month

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!!

Labels (1)
1 Solution

Accepted Solutions
stigchel
Partner - Master
Partner - Master

In Layout Show Condition you can use

Min(Month)<=6

or

Min(Month)>6

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

View solution in original post

3 Replies
sunny_talwar

May be this as a conditional hide/show expression

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

stigchel
Partner - Master
Partner - Master

In Layout Show Condition you can use

Min(Month)<=6

or

Min(Month)>6

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

psk180590
Creator III
Creator III
Author

Thanks both for the quick suggestions.