topic Help with Date input in QlikView

Help with Date input

hopkinsc — Mon, 09 Aug 2010 11:45:16 GMT

I am building a TRANSACTION MODULE which will display ALL transactions that have taken place in our retail stores.

I want the end user to be able to search through transactions between a chosen date range.

E.g.

The end user will enter a START date and END date, then the application will show all transactions between those dates.

The only way i can find to do this is to add SEARCH boxes, so the user can enter directly into them the dates required

My problems are :

If i add 2 search boxes (1 for START date and 1 for END date), and i input a START date, then when i input an END date my start date is erased and only results for my end date is displayed.

Is there a way of keeping my START date selection? and also...

after i input a START or END date, the date is selected, but my search box goes back to SEARCH. Is there a way of keeping the date i have entered displayed in the search boxs until i clear my selections? Or is there another way of the end user to key in start and end dates?

Any help will be appreciated.

Thanks

Help with Date input

Mon, 09 Aug 2010 12:26:03 GMT

Create two separate tables with the date field like [Start Date] and [End Date]

Add two calendar object in the report and map them to [Start Date] and [End Date]

Create two variables 'vStartDate' and 'vEndDate' with the following definitions:

vStartDate = GetFieldSelections([Start Date])
vEndDate = GetFieldSelections([End Date])

We should now use these variables in expression to pass the date range to get the transactions between the date range. The expression will be as follows:

=SUM({<[Trans Date]={">=$(vStartDate)<=$(vEndDate)"}>}Sales)

Assuming [Trans Date] is your date field. This expression will give the value for sales for the dates entered in the two calendar objects which we created.

Hope this resolves your issue.

-Haneesh

Help with Date input

Mon, 09 Aug 2010 12:28:09 GMT

Hi,

I made a sample application about this in my project.I use the steps below.

I create two time tables.StartTimeTable and EndTimeTable.Those two tables don't have any joins with other tables and with each other.
I create two calenders which uses StartTimeTable.Date and EndTimeTable.Date.
Under those two calenders i put a button named "Select Date".I put an "select field" action.In select field action,selection field is RelatedDate. Search string is {">= $(StartTimeTable.Date) <=$(EndTimeTable.Date)"}

After selecting two dates and pressing the button the times will selected as you want.

Help with Date input

Mon, 09 Aug 2010 13:05:14 GMT

Hi,

Instant of making variable you make calender object from_date,To_date.

I have attached sample application herewith kindly find it.

Regards

Ashish Srivastava

Help with Date input

Mon, 09 Aug 2010 14:46:37 GMT

Hi Ashish,

I am tried your application and i got a problem if i am choosing the To Date less than the From Date it is showing some values. Is there any option to restrict this ?????

Regards,XXX

Help with Date input

Tue, 10 Aug 2010 06:09:21 GMT

Try adding a calculation condition in the chart properties such that the from date should be always less than to date and add a corresponding message like 'From date should be lesser than to date'

Ex. if(from_date < To_Date, true(),false())

So, the calculation will be done only when the above condition is satisfied

-Haneesh

Help with Date input

Tue, 10 Aug 2010 08:36:17 GMT

Hi,

I attached modified application herewith find it.

Regards

Ashish Srivastava

Help with Date input

Thu, 12 Aug 2010 13:51:52 GMT

Thanks For your response Ashish,

=if(From < To, sum({<ATIME={">=$(From)<=$(To)"}>} CID),0) .

I trying based on the below steps

ATIME field is in the Datetimeformat. And the From and To condition are from the same ATIME Feild.

Issue is i am getting as numbers(from with decimal value and To as Number ) as selected values inplace of dates.Where as the From and To are based on the same feild ATIME, then why from is decimal and To is number even if i am choosing the same dates.

=if(From < To, sum({<ATIME={">=$(From)<=$(To)"}>} CID),0) .

Moreover i am not getting output.For what ever selection i am getting blank table.

Regards,XXX

Help with Date input

Thu, 12 Aug 2010 14:34:38 GMT

The value is decimal because the feild i have used in the Calender control is of the Datetime format.

Help with Date input

hopkinsc — Thu, 02 Sep 2010 15:17:04 GMT

Hi Karem, Do you have a sample you could post please?