topic Re: Hide Text Box when Month AND Year are selected? in QlikView

Hide Text Box when Month AND Year are selected?

stjernvd — Tue, 14 Jul 2015 17:33:02 GMT

When the user selects a month and several years OR when the user selects a month and NO year is selected the graph looks like this:

The reason being that you can't see results linearly from one month across several years.

I would like to have a text box that tells the user that when they select just one month they must only select one year at a time, or when they select a month and no year is selected they must select a year (one at a time).

And then when they have selected these two conditions, the text box should disappear.

Sorry if this is asking too much at once but would be so helpful.

Danielle

Re: Hide Text Box when Month AND Year are selected?

sunny_talwar — Tue, 14 Jul 2015 17:38:14 GMT

Create a text box with whatever you want your readers to see and conditionally show hide the text box with a condition like this may be:

not (GetSelectedCount(Month) = 1 and (GetSelectedCount(Year) > 1 or GetSelectedCount(Year) = 0))

not (GetSelectedCount(Month) = 1 and GetSelectedCount(Year) = 1)

EDIT: Attaching a sample

Re: Hide Text Box when Month AND Year are selected?

swuehl — Tue, 14 Jul 2015 17:43:00 GMT

Something like

=If( GetSelectedCount( Month ) =1 and GetSelectedCount( Year ) <>1, 'Please select a single year')

In the layout tab of the text box, use a conditional show:

=GetSelectedCount( Month ) =1 and GetSelectedCount( Year ) <>1

edit:

Of course, if you use a conditional show, you don't need the condition in the text expression.

Re: Hide Text Box when Month AND Year are selected?

stjernvd — Wed, 15 Jul 2015 08:35:46 GMT

thank you!

Re: Hide Text Box when Month AND Year are selected?

stjernvd — Wed, 15 Jul 2015 08:35:55 GMT

Thank you so much!