topic Input box and multibox issue in QlikView

Input box and multibox issue

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

Please Can any one help me about this requirement. urgent.

1. i have three multibox and three input boxes.

Data in Inline:

LOAD * INLINE [

Team, Date, Interval, Minutes, Score, Place, Active

India, 2016, T20, 240, 200, India, Y

India, 2016, Oneday, 480, 380, India, Y

India, 2016, 36 Balls, 120, 200, India, Y

India, 2015, T20, 210, 310, AUS, N

India, 2015, Oneday, 580, 280, India, Y

India, 2015, 36 Balls, 180, 100, India, Y

India, 2016, T20, 240, 200, India, Y

India, 2016, Oneday, 480, 380, India, N

India, 2016, 36 Balls, 120, 200, India, N

India, 2015, T20, 210, 310, NZ, N

India, 2015, Oneday, 510, 280, India, Y

India, 2015, 36 Balls, 140, 100, India, Y

AUS, 2016, T20, 240, 200, AUS, Y

AUS, 2016, Oneday, 480, 380, AUS, Y

AUS, 2016, 36 Balls, 120, 200, AUS, Y

AUS, 2015, T20, 210, 310, India, N

AUS, 2015, Oneday, 480, 280, AUS, Y

AUS, 2015, 36 Balls, 120, 100, AUS, Y

AUS, 2016, T20, 240, 200, AUS, Y

AUS, 2016, Oneday, 480, 380, AUS, N

AUS, 2016, 36 Balls, 120, 200, NZ, Y

AUS, 2015, T20, 210, 310, India, N

AUS, 2015, Oneday, 480, 280, AUS, Y

AUS, 2015, 36 Balls, 120, 100, AUS, Y

NZ, 2016, T20, 240, 200, AUS, Y

NZ, 2016, Oneday, 480, 380, NZ, Y

NZ, 2016, 36 Balls, 120, 200, India, N

NZ, 2015, T20, 210, 310, India, Y

NZ, 2015, Oneday, 480, 280, NZ, N

NZ, 2015, 36 Balls, 120, 100, NZ, Y

];

Req:

1. when i give value in input box1 < filed value = have to display multibox1 and hide multibox 2 and multibox 3.

2. when i give value in input box2 < filed value have to display multibox2 and hide multibox 3 and multibox 1.

3. when i give value in input box3 < filed value have to display multibox3 and hide multibox 1 and multibox 2.

Important things: when u give value in input box 1 multibox1 can display and when u give input box2 value Multibox2 also display when u give input box3 the multibox not displaying

continue don't erase values in all inputboxes when i change input value the multibox not reflecting

Check attached file...

Note : Try in your better way... it's help us.

Thanks,

Priya

Re: Input box and multibox issue

omkarvamsi — Fri, 17 Jun 2016 07:28:24 GMT

Hi Priya

1.create a variable vshow and assign a value 1 to it(go to settings->variable over view->ADD)

2. take three input boxes with same variable vshow (this variable should be created in inputbox itself,Be sure all the input boxes should have same value

3 take 3 different multi boxes and Go to Layout conditional of multi-box properties and write as below for each multibox lay out condition

multibox 1: vshow=1

multibox 2: vshow=2

multibox 3: vshow=3

try giving value '1' for input box 1,'2' for input box 2,'3' for input box 3.

Re: Input box and multibox issue

Fri, 17 Jun 2016 08:48:51 GMT

Hi Omkar,

Thanks your valuable to replied me.

I am requesting you to please look into req, I want three different input boxes and three different multiboxes

input box 1 = 30 i want display multibox 1 and multibox have default filters. hide 2 and 3

input box 2 = 100 i want display multibox 2 and multibox have default filters.hide 3 and 1

input box 3 = 30 i want display multibox 3 and multibox have default filters.hide 1 and 2

Main thing i have give values its stores the variable once i want re modify variable and click on enter its not displaying. Can you please check attached file.

Thanks

Priya