Input box Date Validation and Data based on entered values

Fri, 12 Nov 2010 08:07:42 GMT

Hi,

I have a very different requirement.

I have Sales end Month of Products. I have to provide Input Box for Start Month and End Month to the End User where the data has to be filtered on the Entered Months. This is normal requirement.

Here comes a typical requirement:

Month validations has to be done on these two Months(Validation is YYYYMM)

When i dont enter any values in the Start Month and End Month, then my entire data should be shown.

When i Enter only start Month and leave End Month as null, then data should be shown from the entered Month to the Last Month that is avilable in the Data Base.

When i enter End Month and leave Start Month as blank, then data should be shown from the Starting Month available in the database till the entered End Month.

Does anyone have idea how to achieve this.

Input box Date Validation and Data based on entered values

deepakk — Fri, 12 Nov 2010 08:52:47 GMT

I can give you idea to start up.

Create two variable

vMinDate = if(isnull(vTempMinDate) =-1, min(Date),vTempMindate)

vMaxDate = if(isnull(vTempMaxDate) =-1, min(Date),vTempMaxdate)

Here vTempMindate is the variable in the first input box and

vTempMaxDate is the variable in the second inputbox.

Now use the below expression

Sum

({<Date= {">=$(vTempMindate )<=$(vTempMaxDate )"}>} Sales)

)

Hope this helps you out.

topic Input box Date Validation and Data based on entered values in QlikView

Input box Date Validation and Data based on entered values

Input box Date Validation and Data based on entered values