topic Re: Count of Date in QlikView

Count of Date

Wed, 25 Nov 2020 16:16:04 GMT

Hi ,

I need to count number of date between first day of year up today and like this for previous year.

I don't know what to do

please help me;

With Best Regards

Hamide

Re: Count of Date

Tue, 01 Nov 2016 06:34:55 GMT

Hi Hamide,

I hope this will help you out.

This year start date to today:

=num(Today())-num(YearStart(Today()))

Last year start date to today:

=num(Today())-num(YearStart(Today()))+365

Re: Count of Date

eromiyasimon — Tue, 01 Nov 2016 06:35:03 GMT

to calculate today from this year start use below query

=Today()-YearStart(Today())

to calculate today from this previous year start use below query and the minus values goes on for every previous year

=Today()-YearStart(Today(),-1)

hope this helps

Re: Count of Date

Anil_Babu_Samineni — Tue, 01 Nov 2016 06:48:18 GMT

Can you elaborate more

Do you mean Starting Date to Ending Date of the PY

Re: Count of Date

lakshmikandh — Tue, 01 Nov 2016 06:50:27 GMT

YTQ, QTD, MTD and WTD

Count days between current selection in Master Calendar

Year to Date vs Year to date Last Year

Re: Count of Date

engishfaque — Tue, 01 Nov 2016 06:55:35 GMT

Hi Hamide,

Here it is,

=Today() - YourDateField

=YourEndDate - YourStartDate

Kind regards,

Ishfaque Ahmed

Re: Count of Date

ecolomer — Tue, 01 Nov 2016 07:06:27 GMT

Days between today and first day of year:

=Today() - yearStart(today())

From Previous year to first day of year:

= yearStart(today()) - AddYears(Today(),-1)

Re: Count of Date

jonathandienst — Tue, 01 Nov 2016 07:55:12 GMT

Counting off same number of days in previous year

=YearStart(Today(), -1) + (Today() - YearStart(Today()))

Re: Count of Date

Wed, 02 Nov 2016 06:14:33 GMT

Hi,

Thanks for your answer, but my date is shamsi date

I want calculate the number of date between 1/1/1395 up today(12/8/1395) ;

My answer should be : 228

Regards

Re: Count of Date

Anil_Babu_Samineni — Wed, 02 Nov 2016 06:30:31 GMT

Try Some thing Like this and then we can help you OR Please provide me sample Data which demonstrates the o/p

Count(Date(Interval(1/1/1395 - 12/8/1395),'DD/MM/YYYY'))