topic Re: dynamically How to set the values in input boxes manually in QlikView

dynamically How to set the values in input boxes manually

Fri, 20 May 2011 10:19:31 GMT

Helo evryone,

i have a two input vaiables Min and Max in input box.

so manually we are entring the data for min and max

how to set the data for min and max in dyanamically

Many thanks

vasu

dynamically How to set the values in input boxes manually

kaushiknsolanki — Fri, 20 May 2011 10:54:03 GMT

Hi,

You can assign an initial value to your varibale, which will be seen in your input box.

Go to Input Box Properties- > constraints - > Setting for selected variables -> set value

Hope this will help you

Regards,

Kaushik Solanki

dynamically How to set the values in input boxes manually

Fri, 20 May 2011 11:43:54 GMT

Hi Kaushik thanks for ur quick reply

my requirment has been change now.

i have table having the feild name along with min and max values

i need to select the feild1 and disply the defalut min and max values from above tabel in slider

if i am change the range from slider so autometicall updated the above tabel with selcted min and max range

plz help me on this

Many Thanks

vasu

dynamically How to set the values in input boxes manually

kaushiknsolanki — Fri, 20 May 2011 11:48:45 GMT

Can you please describe with an example

Thanks

Kaushik Solanki

dynamically How to set the values in input boxes manually

suniljain — Fri, 20 May 2011 11:57:20 GMT

Dear Kaushik,

you can assign required value to variable and then assign that variable to input field.

i hope , it will help you.

Re: dynamically How to set the values in input boxes manually

kaushiknsolanki — Fri, 20 May 2011 12:09:43 GMT

Hi,

I am here by sending you an example.

Hope this is what you are looking for

Regards,

Kaushik Solanki

dynamically How to set the values in input boxes manually

Fri, 20 May 2011 12:26:04 GMT

Hi Kaushik,

i have a table having 3 cloumns having 2 rows data.

1.feildname

2.min

3.max

i have create the group for feildnames

and group placed in chart

bottom of the chart placed in one slider.

when ever i select the one feild from group list form chart and set the deflut min and max values to slider.

those min and max getting from above tabel.

then my requirment is when ever i chage the default time from slider.now the min and max valude are changed right through slider.

the changed min and max values must be update to the aboove table.

how it is possibleplz help me on this

Thanks alot

vasu.i

Re: dynamically How to set the values in input boxes manually

kaushiknsolanki — Fri, 20 May 2011 12:48:39 GMT

Hi,

I am here by sending you updated one

Due to my time limit i can just complete it to set first raw value.

I will send you with more dynamic way tomorrow.

Regards,

Kaushik Solanki

Re: dynamically How to set the values in input boxes manually

kaushiknsolanki — Fri, 20 May 2011 13:06:24 GMT

Hi,

I have checked the above example.

Its working fine.

All you have to do is Select one Value and then set the min and max values

Hope this is what you wanted.

regards,

Kaushik Solanki

Re: dynamically How to set the values in input boxes manually

Fri, 20 May 2011 14:57:27 GMT

Many Many Thanks Kaushik,

it's working here also,plz send how to update tabel autometically when i am slecting the range from slider.for a selected data A or B or C

Many thanks Kaushik

vasu.i

Re: dynamically How to set the values in input boxes manually

kaushiknsolanki — Sat, 21 May 2011 06:11:30 GMT

Hi,

Until i know, its not possible to update the table with change in slider.

The reason is the macro is called only when you click on button.

If this is help full. then can you mark this post as solved. I mean mark with correct ans.

Thanks & Regards,

Kaushik Solanki

Re: dynamically How to set the values in input boxes manually

Sat, 21 May 2011 06:54:53 GMT

Hi Kaushik that is fine then i need like

ex:as per u r example tabel having fisrt column data (A,B,C,D...)

in my group BC having (A,B,C,D....)

take bar chart and placed group.

if i am selecting the A from group the data show in bars right.

i am giving the min and max vaules from tabel

how the data will be effected in chart when we entring the min and max values for concerned feilds(A,B,C,D....)

plz need help on this ...

Many Thanks

vasu.i

Re: dynamically How to set the values in input boxes manually

kaushiknsolanki — Sat, 21 May 2011 07:06:45 GMT

Hi,

I am not clear what you are saying.

But when you change the min and max values by clicking on the button, same will be reflected in your bar chart.

Try it works.

Regards,

Kaushik Solanki

Re: dynamically How to set the values in input boxes manually

Sat, 21 May 2011 07:22:49 GMT

Many Thanks Kaushik for ur quick reply

ur table having like

feild min max

A 3 9

B 4 6

C 5 8

D 8 44

in the above tabel having input boxes for min and max right

then if i am givig the min and max for A in tabel it self

is it also reflected in Bar chat for A data.

i am tring on this

if it is not woking i will inform you kaushik.

Many Thanks

vasu.I

Re: dynamically How to set the values in input boxes manually

kaushiknsolanki — Sat, 21 May 2011 07:29:39 GMT

Hi,

Sure, Anytime.

Can you mark this post as Answered.

Regards,

Kaushik Solanki

Re: dynamically How to set the values in input boxes manually

Sat, 21 May 2011 07:46:13 GMT

Thanks Kaushik Solanki

Re: dynamically How to set the values in input boxes manually

Sat, 21 May 2011 10:57:01 GMT

Hi ,Kaushik Solanki

here i placed my requirment for data souce filter

how will you design for this filter in qilkview.

Theuser should be given a choice to select either TABEL1 orTABEL2 And TABEL3. Thereshould be three options to select the data source. The options are TABEL1 , Individual TABEL1,TABEL2 table, Multiple TABEL1,TABEL2 tables.

There should be acheck box against each option, so that anyone of them can be selected or acombination of them can be selected. When TABEL 1 data source is selected, then there must be an option to sub select two options in TABEL1.

The two options are

option1
option2

Both the aboveoptions should have

a radio button against them so that user can select eitherof them.

Plz help me on this

Many Thanks

vasu

dynamically How to set the values in input boxes manually

kaushiknsolanki — Sat, 21 May 2011 11:04:05 GMT

Hi,

I am unable to understand u r requirement.

Can you please explain with an example

Regards,

Kaushik Solanki

Re: dynamically How to set the values in input boxes manually

Sat, 21 May 2011 12:12:44 GMT

Dear Kaushik Solank the above design was cleard.

and the previuos i asked about data effecting the on chart when the we are entring the data in table by using Inputfeild for Min and Max;

here the chart will not effected when chnage the min and max in a table it self.

plz help me on this

Many thanks

vasu

dynamically How to set the values in input boxes manually

kaushiknsolanki — Sat, 21 May 2011 16:37:22 GMT

hi,

Can you upload the QVW file, for more clerification.

Thanks,

Kaushik Solanki