topic Re: Hide / unhide textbox depending on values in QlikView

Hide / unhide textbox depending on values

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

hi,

I have a list of expression and multiple text box.

I need the following:

- if I choose expression 1 and 2 , textbox 1 and 2 will be displayed with the values of expression 1 and 2

- if I choose expression 1 , 4 and 7, the textbox 1 , 2 and 3 will be displayed with the values of expression 1 ,4 and 7

-ect,..

please advise

Re: Hide / unhide textbox depending on values

sunny_talwar — Fri, 23 Aug 2019 13:36:49 GMT

You can set unconditional display statement like this

Text Box 1 -> GetSelectedCount(ExpressionField) >= 1
Text Box 2 -> GetSelectedCount(ExpressionField) >= 2
Text Box 3 -> GetSelectedCount(ExpressionField) >= 3
Text Box 4 -> GetSelectedCount(ExpressionField) >= 4
Text Box 5 -> GetSelectedCount(ExpressionField) >= 5
Text Box 6 -> GetSelectedCount(ExpressionField) >= 6
Text Box 7 -> GetSelectedCount(ExpressionField) >= 7

Re: Hide / unhide textbox depending on values

felipedl — Fri, 23 Aug 2019 13:38:29 GMT

You can use the Layout part of the chart to set this kind of property based on what you need

And using a simple if statement, like if(Whatever is true, 1,0) it will show / hide the needed panel.

Felipe.

Re: Hide / unhide textbox depending on values

felipedl — Fri, 23 Aug 2019 13:39:47 GMT

@sunny_talwar , you're lightning fast on the responses, save some for us 😆.

Re: Hide / unhide textbox depending on values

sunny_talwar — Fri, 23 Aug 2019 13:40:41 GMT

I responded 6 minutes after the question was posted... that seems to me as Sloth slow 😉

Re: Hide / unhide textbox depending on values

sunny_talwar — Fri, 23 Aug 2019 13:42:02 GMT

Also, both our answers are incomplete individually, but together we gave the complete solution. So, isn't this awesome?

Re: Hide / unhide textbox depending on values

joelle_alhanna — Fri, 23 Aug 2019 14:17:15 GMT

what I meant is: for every time I change the selected expressions, textbox will be filled one after the other and in order of expression, the remaining text box will be hidden.

please find attached

Re: Hide / unhide textbox depending on values

sunny_talwar — Fri, 23 Aug 2019 14:23:14 GMT

I believe so... what exactly is the issue here?