Discussion Board for collaboration related to Creating Analytics for QlikView.
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?
Go to Solution.
Updated sample as per your need -
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.
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
Check this sample -
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....
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.
SO SHALL I create the variable at script level ...,,like this
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
what i missing out is this
?(what condition should i need to write here under this dim)
?(what condition should i need to write here)
sorry for annoying you man......
Did you check this?