topic Input Box with Constraints from data column in QlikView

Input Box with Constraints from data column

Tue, 05 Nov 2013 13:08:19 GMT

Hi I'd like to add on an input box constraints from my data values (InsertDate column) is that possible?

I'm using constraints for empty and dates less or equal to today with:

len(date(date#($))) > 0 AND date#($) <= Today()

Thats my data example:

LOAD

Customer,

Category,

date(InsertDate) as InsertDate

FROM

$(vPath)xsData.qvd

Re: Input Box with Constraints from data column

Carlos_Reyes — Wed, 06 Nov 2013 23:06:44 GMT

What are you exactly trying to do with the input box?

I would suggest to load an island date field that has all the valid values you need.

Re: Input Box with Constraints from data column

Thu, 07 Nov 2013 09:12:01 GMT

The input box is used for a date filter. It is date format. I'd like to restrict inputs to dates that exists in my data table (InsertDate field). Is this possible through constraints?

Something like:

$(=Count({$<InsertDate = {">= ...... <=......."}>} InsertDate)) > 0

Re: Input Box with Constraints from data column

israrkhan — Thu, 07 Nov 2013 09:23:34 GMT

Hi, Use Min and Max Functions like below, make correction in the syntax.

and make sure your entered date format should be same format as you have in date fiels.

or use variables for min and max date, and the use those variable in conditions...

$(=Count({$<InsertDate = {">= $(=Min(InsertDate) , <= $(=Max(InsertDate)"}>})

Re: Input Box with Constraints from data column

tresB — Thu, 07 Nov 2013 09:29:10 GMT

Try using Concat() function like:

Predefined Values->Listed Values

Expression:

=Concat({$<InsertDate = {">= ...... <=......."}>} InsertDate, ' ; ')

Re: Input Box with Constraints from data column

a_mullick — Thu, 07 Nov 2013 09:53:32 GMT

Hi,

I've got a possible solution for you. To constrain a varaible against a predefined list means defining some values like:

'a'; 'b'; 'c'

So what I've done is load a quoted version of the InsertDate (referred to as DropDownDate in the script) which can be used to build such a string. Another option though (unless you really need to store the date in a variable) is to use a calandar object. See the attached qvw

Re: Input Box with Constraints from data column

Thu, 07 Nov 2013 11:25:02 GMT

I'm asking about the current inserted (by user) date on a custom "input constraint". I want to accept only dates that exists on data.

an example that works with variable is: $(=Count({$<InsertDate= {"<=$(vDateIns)>=$(vDateIns)"}>} InsertDate))

i want to instead of a variable to check the inserted by user date and if it has count number >0 to accept the date, else i display the error message like one other constraint i have: date#($) <= Today()