topic Re: Date Help in QlikView

Date Help

sona_sa — Thu, 10 Apr 2014 11:26:10 GMT

Hi,

Suppose I have a date filed and max date is 31/12/2014 (DD/MM/YYYY) and I have to make a expression as on date. How we can make a expression = to count of employeeheadcpunt on the behalf of same date. But want as on date employeeheadcount.

Thanks.

Re: Date Help

MK_QSL — Thu, 10 Apr 2014 11:27:29 GMT

COUNT({<Date = {'31/12/2014'}>}Employee)

COUNT({<Date = {'$(=Max(Date))'}>}Employee)

COUNT({<Date = {'31/12/2014'}>}Distinct Employee)

COUNT({<Date = {'$(=Max(Date))'}>}Distinct Employee)

Re: Date Help

MayilVahanan — Thu, 10 Apr 2014 11:30:57 GMT

Try like this

Count({<Date = {"$(=Date(Max(Date)),'DD/MM/YYYY')"}>}Distinct employeehead)

Re: Date Help

Thu, 10 Apr 2014 11:33:38 GMT

Try this

Create variable vMaxDate=Date(Max(Date),'DD/MM/YYYY')

COUNT({<Date = {"<=$(vMaxDate)"}>}Employee)

COUNT({<Date = {"<=$(vMaxDate)"}>}Distinct Employee)

Re: Date Help

sona_sa — Thu, 10 Apr 2014 12:07:04 GMT

But suppose Today is 10/04/2014, I don't want maxdate, of my dimension fields. In my database till 2016 data is available, but whatever date is today and when my qvd is refreshed last time, I want till date data.

Thanks

Re: Date Help

its_anandrjs — Thu, 10 Apr 2014 12:13:25 GMT

From max date you get max value which is your database date field like with this script

Count({< Date = {'$(=Date(Max(Date)),'DD/MM/YYYY')}>} employeehead)

Re: Re: Date Help

Thu, 10 Apr 2014 12:13:34 GMT

Such case use this for variable

vMaxDate=Date(Today(),'DD/MM/YYYY')

Re: Date Help

sona_sa — Thu, 10 Apr 2014 12:50:15 GMT

In Case My QVD is not reloaded and yesterday data is there, then it will not use today() function.

Re: Date Help

Thu, 10 Apr 2014 12:54:12 GMT

Use this

vMaxDate=Date(ReloadTime())