Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

kunkumnaveen
Contributor III

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
Honored Contributor III

Re: hide and show few fields based up on textboxs click

Updated sample as per your need -

13 Replies
Digvijay_Singh
Honored Contributor III

Re: hide and show few fields based up on textboxs click

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
Honored Contributor II

Re: hide and show few fields based up on textboxs click

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
Honored Contributor III

Re: hide and show few fields based up on textboxs click

Check this sample -

kunkumnaveen
Contributor III

Re: hide and show few fields based up on textboxs click

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
Honored Contributor III

Re: hide and show few fields based up on textboxs click

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
Contributor III

Re: hide and show few fields based up on textboxs click

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
Honored Contributor III

Re: hide and show few fields based up on textboxs click

Updated sample as per your need -

kunkumnaveen
Contributor III

Re: hide and show few fields based up on textboxs click

HI

what i missing out is this

TEXTBOX1:                             

Vselectvar=1;

quantity dimSmiley Sadcondition)

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

TEXTBOX2:

Vselectvar=2;

TM dimSmiley Sadcondition)

?(what condition should i need to write here)

TEXTBOX3:

Vselectvar=3

GVM dimSmiley Sadcondition)

   ?

sorry for annoying you man......

thanks

naveen

Digvijay_Singh
Honored Contributor III

Re: hide and show few fields based up on textboxs click

Did you check this?

Community Browser