topic Re: Input Box and Load Data in QlikView

Input Box and Load Data

jagjivvt — Tue, 14 Feb 2017 15:19:16 GMT

Hi,

i need to load data that has a field Date and Time. i have created an input box where i insert the date and time and using where clause in the load script i have a variable. however when applying this it does not load any data.

example

ActivityDate 06/02/2017 15:01:30

My data has various dates in the file and only want to load the rows that are greater then the above date.

in the load script is have right "Where ActivityDate>'$vActive';

thanks

vijay

Re: Input Box and Load Data

vishsaggi — Tue, 14 Feb 2017 15:33:05 GMT

May be try this?

Where Date(Date#(ActivityDate, 'MM/DD/YYYY hh:mm:ss' ), 'MM/DD/YYYY hh:mm:ss') > '$(vActive)' ;

OR This?

Where Date(Date#(ActivityDate, 'MM/DD/YYYY hh:mm:ss' ), 'MM/DD/YYYY hh:mm:ss') > Date(Date#('$(vActive)' , 'MM/DD/YYYY hh:mm:ss'), 'MM/DD/YYYY hh:mm:ss')

Re: Input Box and Load Data

jagjivvt — Thu, 16 Feb 2017 13:08:42 GMT

thanks tried both but no success

vijay

Re: Input Box and Load Data

vishsaggi — Thu, 16 Feb 2017 13:11:50 GMT

Can you share your app you are working on, when i used my test data it worked fine. It would be easy if i can look into your app to work on?

Re: Input Box and Load Data

jagjivvt — Thu, 16 Feb 2017 16:02:26 GMT

please see attached qvw and the excel workbook

thanks

Re: Input Box and Load Data

vishsaggi — Thu, 16 Feb 2017 16:23:17 GMT

Try this by changing your excel path.

Keep changing your variable dates and reload.

Re: Input Box and Load Data

jagjivvt — Thu, 16 Feb 2017 16:51:36 GMT

Thanks , this works perfect.