topic Re: LOGIC HELP in QlikView

LOGIC HELP

abhaysingh — Wed, 27 Jan 2016 09:40:51 GMT

hI,

iN a calendar i have date for whole month, let sat for jan 1 to 31

now i need to check todays date let say, 27 jan 16

than it should calculate less than days , todays days, output is 26 days for jan month.

kindly help

jonathandienst — Wed, 27 Jan 2016 09:44:31 GMT

First load the dates as proper QV date fields, then use something like:

= Floor(myDateField) - MonthStart(myDateField)

Anonymous — Wed, 27 Jan 2016 09:44:40 GMT

use: day(today())-1 gives you 26 for today

Anonymous — Wed, 27 Jan 2016 09:45:31 GMT

like this?

=count({<Date={'>=$(=date(monthstart(today),'YourFormat'))<=$(=date(today,'YourFormat'))'}>} distinct Date)

Peter_Cammaert — Wed, 27 Jan 2016 09:56:22 GMT

Do you want this expression to work only for the current month? Or also for all preceding months?

For example, if today is Feb 4th, the expression needs to return 3 for February and 31 for January?

Anonymous — Wed, 27 Jan 2016 09:59:37 GMT

If it is like Peter Cammaert asked for all preceding months, then replaced today() with max(Date)