topic Re: Problem with date in set analysis in QlikView

Problem with date in set analysis

Tue, 28 May 2013 13:19:43 GMT

Good Afternoon all,

I have the following code in my load script in QV11.

num (SECTION_DATE) as Working_Date

and have tried the following piece of set analysis

=count ( { < Working_Date = {'>num(today())'} >} CLIENT_NO)

However this brings back 0.

If I hard code the integer for todays date currently 41422

=count ( { < Working_Date = {'>41422'} >} CLIENT_NO)

I get the correct result

Can anyone advise why the num(today()) funtion is not working in my set analysis please?

Many thanks in advance

Mike

Gysbert_Wassenaar — Tue, 28 May 2013 13:23:30 GMT

Try =count ( { < Working_Date = {'>$(=num(today()))'} >} CLIENT_NO)

Tue, 28 May 2013 13:26:03 GMT

Brilliant - Thank you so much for for your help!

Tue, 28 May 2013 13:26:40 GMT

Brilliant - Thank you so much for your help!!

Tue, 28 May 2013 13:29:01 GMT

try this

=count ( { < Working_Date = {'>$(=num(today()))'} >} CLIENT_NO)

Tue, 28 May 2013 13:37:34 GMT

Thank you