topic Input Field with Predefined list of positive integers in QlikView

Input Field with Predefined list of positive integers

Thu, 25 Mar 2010 08:32:01 GMT

Dear Forum,

I need a drop down with few pre-defined integer values which will be used for dividing other fields, for ex in expression one can write = sum ( if ( Date < date(today()), Total_Sales) / max ( 1, InUnitsOf )............... This InUnitsOf is what i want to come from input field. Can anyone tell me how to add these value (1,10,100 etc...) in input field.

Input Field with Predefined list of positive integers

lironbaram — Thu, 25 Mar 2010 09:05:13 GMT

hei

i wouldn't use input field if i can avoide it

what you described as i see it seem that a Variable would do the work

then you can just defined in the input box object the values for the Drop down list

Input Field with Predefined list of positive integers

Thu, 25 Mar 2010 10:26:08 GMT

Thanks RoiUser,

Can u describe a little bit, Can anyone define an array of values in a variable like vInUnitsOf = { 0, 10, 100, 1000 ) .

i should do in Properties->Constraint->Predefined Values and check the Listed values.

I tried that but it was not working properly, if u can tell me the full procedure that will be gr8.

Input Field with Predefined list of positive integers

neetu_singh — Thu, 25 Mar 2010 10:51:16 GMT

Hi,

Can u try this. As per my knowledge may be u r looking for this.

U can do

select object Input Box ---> Declare New Variable ----> Click on Input box Properties -------> Constraints Tab --------> Check the (Predefine Value in drop down) -------> on right side there is a box (Predefine value) --------> check on number series --------> define ur starting & ending point in "From" and "TO" box as : in From : 0 and To :1000

define static step: whatever u want

If u want calculated then put expression in Listed Values Checkbox.

May be it will help out u.

Bye nd TC

Input Field with Predefined list of positive integers

Thu, 25 Mar 2010 14:41:27 GMT

Thanks Neetu,

But in this case there is no fixed steps, like users generally want to divide by 1, 10, 100, 1000, 10000, 100000 etc... sometimes 12 then i can't give steps in List.

Input Field with Predefined list of positive integers

Thu, 25 Mar 2010 14:50:05 GMT

Hi,

In your input box properties, tab "constraints", choose "predefined values only" as input constraints and then check the "listed values" box and type 1;10;100 to have values 1, 10 and 100 as pre-defined integers.

Input Field with Predefined list of positive integers

Fri, 26 Mar 2010 10:40:34 GMT

Thanks cchicaud,

It worked exactly what i want.

Bye

Input Field with Predefined list of positive integers

rahulgupta — Fri, 04 Feb 2011 07:26:03 GMT

Hi, Its fine but plz can u tell me how to use a list of Values from a Field in a Input Box. Eg I Have a Field Say : ReportName containg Data : Report1,Report2,Report3 I have made these values Dynamic by section Access, Eg User1 can see Report1 and Report2 Report1,report2,report3... are the field values in the Field ReportName