Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Hide and show textbox based on field Value

Hi All,

Hide and show text box based on field Value, below my req is there:

Req:

I have table Like:

Table:

Name, Score

A, 15

B, 18

C, 19

D, 20

E, 22

Example:

   Req.png

Textbox_1 and Textbox_2 is Fix, when Textbox_2 Value( Like Score) > 18 I need to display Textbox_3 and When TextBox_n Value> 19 Show Textbox_n and HideTextbox_3 with Value(Score).

kindly help me as soon as possible.

Divya.

1 Solution

Accepted Solutions
kkkumar82
Specialist III
Specialist III

Hi divya,

Please find attached file and let me know if it satisfies your requirement.

Thanks

Kiran

View solution in original post

13 Replies
MayilVahanan

Hi


Try like this


Textbox 3 -> Layout -> Conditional


Textbox_2 > 18 and TextBox_n < 19

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
kkkumar82
Specialist III
Specialist III

Hi divya,

goto the proerties -> Layout -> Show - > conditional    of third text box and write the expression of second text box there

like sum(expression2)>0.

don't forget to select "conditional "radio button for third text box.

Thanks

Kiran kumar

Not applicable
Author

Can you please help me with code Mayil.

Divya.

Not applicable
Author

Can you please help me with code Kiran.

Divya.

kkkumar82
Specialist III
Specialist III

Hi Divya,

Did you get the solution , if not post a sample

Thanks

Kiran Kumar

Not applicable
Author

Hi Kiran,

I have been attached QVW. Can you please check and let me know. or else share ur mail id i will drop a mail.

Thanks.

Divya

saurabh5
Creator II
Creator II

You can achieve this by putting a condition for the layout of the text object as mentioned by others folks. Looking at the Qvw attached i don't see the expressions which will be shown on text object, as the expression would be deciding factor for the condition, or if there is list box which selects only one score then you can use the function getfieldselections() for the condition.


Thanks

Not applicable
Author

Hi Saurabh,

I have attached QVW file, in this file have data and my req i have been updated above Discussion...

kkkumar82
Specialist III
Specialist III

Hi Divya,

Even though the requirement is not clear, I tried something, but in reality you have to use a function in the layout -> show -> conditional expression.

to see all the hidden objects press  CTRL + SHIFT + S

Regards

Kiran