topic Re: comparison using set analysis in QlikView

comparison using set analysis

Wed, 14 Aug 2013 11:08:51 GMT

Hi,

I want to compare the end date with the current date within a set expression,if the end date is lesser than the current date,i would want to perform a count on empid i.e., I need a function to perform something like this count({$<End={'<today()'}>}Emp_ID) .So can anyone explain how this could be acheived?

Re: comparison using set analysis

tresB — Wed, 14 Aug 2013 11:14:14 GMT

try like:

Count({<End={'<$(=Date(Today()))'}>} Emp_ID)

Re: comparison using set analysis

Wed, 14 Aug 2013 11:14:56 GMT

count({<End = {"<$(=today())"}>} Emp_ID)

Re: comparison using set analysis

MayilVahanan — Wed, 14 Aug 2013 11:41:01 GMT

Try like this

Count({<End={'<$(=Date(Today()))'}>} Emp_ID)

And make sure , the date format are similar. If vary,

Try with

Count({<End={'<$(=Date(Today(),'MM/DD/YYYY'))'}>} Emp_ID)

Instead of 'MM/DD/YYYY' -> use ur format

Re: comparison using set analysis

Wed, 14 Aug 2013 11:58:19 GMT

Hi Mayil,

Thanks for the solution

Re: comparison using set analysis

Wed, 14 Aug 2013 13:10:21 GMT

Can you you please explain how the same functionality could be achieved by equating the end date’week to today’s week within the same set expression