topic Re: Date Issues in QlikView

Date Issues

Anonymous — Wed, 17 Jan 2018 23:48:23 GMT

I have field (DateID) with a list of dates for example Jan-1-2018 , Jan-2-2018..... Jan-15-2018. I am using this in my set expression as

P(DateID) which shows all the dates.

There is another date AuthDate which is equal to say Jan-10-2018, then the set expression should use only the dates leading upto Jan-10-2018

How do I achieve this ?

Anil_Babu_Samineni — Thu, 18 Jan 2018 00:17:01 GMT

If those dates co-associates to each then expression looks

Sum({<DateID = P({<AuthDate = {"<=$(=Date(YearStart(Today()), 'MMM-DD-YYYY'))"}>} DateID)>} measure)

Anonymous — Thu, 18 Jan 2018 04:12:25 GMT

Why is the Date(YearStart(Today()), 'MMM-DD-YYYY' used in the expression?

pradosh_thakur — Thu, 18 Jan 2018 05:52:54 GMT

what about

Sum({<DateID = P({<DateID={"=(AuthDate>=DateID)"}>} DateID)>} measure)

note: it will include all dates prior to AuthDate and not only confined to current year.