Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
kunkumnaveen
Specialist
Specialist

hide and show few fields based up on textboxs click

Hello guys...

these are the fields i had added in the straight table as a dimension.....now i need hide and show  few fields based up on click on textboxs


PLACE    SHIP        QUANTITY     TM      GVM     AVM



what i mean is i took 4 textboxs:


if i click on TEXTBOX1:then i should display these three fields only

                         PLACE         SHIP               QUANTITY-------------------------------->(HIDE TM,GVM)


if i click on TEXTBOX2:then i should display these four fields only

                          PLACE            SHIP                 QUANTITY               TM---------->(HIDE GVM)


if i click on TEXTBOX3:then i should display these three fields only

                            PLACE           SHIP                 GVM------------------------------------->(HIDE QUANTITY, TM)




What i assume is to achieve this task i need to write a condition under each dimension  in that straight table.......am i right?

thanks

naveen

1 Solution

Accepted Solutions
Digvijay_Singh

Updated sample as per your need -

View solution in original post

13 Replies
Digvijay_Singh

You can set value of variable based on button clicked or text box clicked and check the value of variable in Enable condition in dimension tab of straight table.

lironbaram
Partner - Master III
Partner - Master III

replay yes

here are the steps

create a variable let say vSelectedDims

then assign action to each text box

for example for text box 1 ->set variable vSelectedDims to 1

and so on

then in your straight table for each dimension there should be condition

for example :

for Quantity the condition should be vSelectedDims <>3

for Gvm vSelectedDims =3

and so on

Digvijay_Singh

Check this sample -

kunkumnaveen
Specialist
Specialist
Author

HI,

so you mean do i need to create each variable for each textbox........can you help me with writing down one example

and i will follow the rest .......but i think challenge is on clicking text box 2 i need to display two fields....

Digvijay_Singh

One variable is enough for all, use condition in dimension like - DimCond=1 or DimCond =2 when same field to be displayed through more than 1 text box.

kunkumnaveen
Specialist
Specialist
Author

HI,

SO SHALL I create the variable at script level ...,,like this

set  vSelectedDims;

what condition should i need to write on TM Dimension..

beacause when i click on textbox2 i need to see these filelds

PLACE   SHIP QUANTITY  TM

Digvijay_Singh

Updated sample as per your need -

kunkumnaveen
Specialist
Specialist
Author

HI

what i missing out is this

TEXTBOX1:                             

Vselectvar=1;

quantity dim:(condition)

  ?(what condition should i need to write here under this dim)

TEXTBOX2:

Vselectvar=2;

TM dim:(condition)

?(what condition should i need to write here)

TEXTBOX3:

Vselectvar=3

GVM dim:(condition)

   ?

sorry for annoying you man......

thanks

naveen

Digvijay_Singh

Did you check this?