topic Re: Hide and show textbox based on field Value in QlikView

Hide and show textbox based on field Value

Fri, 29 Jan 2016 09:26:54 GMT

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:

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.

Re: Hide and show textbox based on field Value

MayilVahanan — Fri, 29 Jan 2016 12:16:17 GMT

Try like this

Textbox 3 -> Layout -> Conditional

Textbox_2 > 18 and TextBox_n < 19

Re: Hide and show textbox based on field Value

kkkumar82 — Fri, 29 Jan 2016 12:17:33 GMT

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

Re: Hide and show textbox based on field Value

Fri, 29 Jan 2016 15:19:58 GMT

Can you please help me with code Mayil.

Divya.

Re: Hide and show textbox based on field Value

Fri, 29 Jan 2016 15:20:57 GMT

Can you please help me with code Kiran.

Divya.

Re: Hide and show textbox based on field Value

kkkumar82 — Mon, 01 Feb 2016 14:40:34 GMT

Hi Divya,

Did you get the solution , if not post a sample

Thanks

Kiran Kumar

Re: Hide and show textbox based on field Value

Mon, 01 Feb 2016 15:47:58 GMT

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

Re: Hide and show textbox based on field Value

saurabh5 — Mon, 01 Feb 2016 16:25:26 GMT

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

Re: Hide and show textbox based on field Value

Mon, 01 Feb 2016 16:47:52 GMT

Hi Saurabh,

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

Re: Hide and show textbox based on field Value

kkkumar82 — Mon, 01 Feb 2016 17:49:06 GMT

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

Re: Hide and show textbox based on field Value

Tue, 02 Feb 2016 05:57:44 GMT

Hi Kiran,

It's really good. My req is No selection n no action here.

I have a table:

Name, Points

A, 2

B, 3

C, 0

D, 2

Requirement is:

I have Three Text boxes:

Texbox 1: We have to display Value 3 as Static.

TextBox 2: Have to display value as 6 as static

Text 3: Have to display Greater than the Textbox_2 value

Ex: in textbox2 value 6 and i want display sum(Points) like Value '7' is in Textbox 3 using Hide and show

Hide and show means : Textbox 3 value greater than Textbox 2 then only want to display textbox3 value.

Can you please anyone help this.

Divya.

Re: Hide and show textbox based on field Value

kkkumar82 — Tue, 02 Feb 2016 08:37:31 GMT

Hi divya,

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

Thanks

Kiran

Re: Hide and show textbox based on field Value

vipin_mishra479 — Tue, 02 Feb 2016 09:26:57 GMT

Please check

Re: Hide and show textbox based on field Value

Wed, 03 Feb 2016 08:57:29 GMT

hi Kiran,

It's Corecct. Thank you.

I have a table:

Table:

Name, Points

A, 2

B, 3

C, 0

D, 2

When ever table data is updated the sum(points) Score shown in new textbox.

Can you please Add two more Txtboxes and Show updated value into that txt using hide and show

Example:

Textbox_1 = Static

Textbox_2 = Static

Textbox_3 = Sum

Textbox_4 = Sum_Updated value When showing Text4 We have to hide txt3 and show tx4

TextBox_5 = Sum_Updated value When showing Text5 We have to hide txt3 and txt4 and show tx5 value.

Thanks

Divya