topic Re: Count of Day, Between two dates in QlikView

Count of Day, Between two dates

Thu, 03 Jul 2014 19:35:28 GMT

Hi,

Could please send me the expression for count of day between two different dates.

Suppose, I have selected Start Date as 1-Jan-2014 and End Date as 11-Jan-2014. and there is another column, which have day information. I need count of particular day falling between this period.

So suppose, if the day is monday, the count will be 1 and if it is Thursday, the count will be 2.

Re: Count of Day, Between two dates

MK_QSL — Thu, 03 Jul 2014 20:59:02 GMT

Unclear from your question... can you please elaborate with one more good example?

Re: Count of Day, Between two dates

erivera10 — Thu, 03 Jul 2014 23:03:44 GMT

The question is not clear, but what is meant is that you need to count the days between a date range. You can take this time directly from the table of Date_example field as I did in my example or you can delimit it with the "create calendar / slider object", which is found in the design of Qlikview, Rear mind to apply the code in the "Object text" annexed qvw and excel.

Re: Count of Day, Between two dates

Fri, 04 Jul 2014 03:28:43 GMT

Example:

Start Date : 1-Jan-2014

End Date: 11-Jan-2014

So between the start and end date, MONDAY falls one time. So I am looking for an expression which give count MONDAY between start and end date.

I am maintaining one column, which has list of all days, So if the input will be monday, the output from the expression will be 1. Similarly, Friday falls two times between start and end date, so the output will be 2.

Please let me know, if any problem while understanding the above example. so that i will try to give some other good example.

Thanks

Re: Count of Day, Between two dates

erivera10 — Fri, 04 Jul 2014 14:26:19 GMT

I think I get it, you need to have specific days between the start date and end date. For this you need to apply the "where" command in the "script" or a condition in typical expression, count (date_example = 'Mon'), something may work, it is a matter for you to try and search examples. Question to explore is, that it left me a lot of knowledge.