topic Re: get the cursor's selection value in QlikView

get the cursor's selection value

Fri, 07 Feb 2014 08:04:42 GMT

Hello every body

I have a cursor object and im selecting dates by expression, my problem is that the other fields are comparing with today's date not the selection date , so how do i get the value of the selection to compare with instead of today's date ?

Best Regards

Re: get the cursor's selection value

Fri, 07 Feb 2014 08:46:49 GMT

can you post the expersion used or the sample app for the same ...

Re: get the cursor's selection value

Fri, 07 Feb 2014 08:49:19 GMT

OK mr Nagaraj,

=Num(if (Num(Month([Date CA]))=Num(Month(Today())) and Num(year([Date CA]))=Num(year(Today())) and Num(day([Date CA]))<=Num(day(today())) ,([Date CA])))

Regards

Re: get the cursor's selection value

ashwanin — Fri, 07 Feb 2014 08:53:51 GMT

You need to modify the expression.

here it is = today() in your expression,

Change it to the Field name of Your Selection Date field.

Re: get the cursor's selection value

Fri, 07 Feb 2014 08:57:43 GMT

In addition to the change mentioned by Ashwani Kumar - you don't have to split the date into Year/Month/Day. Date is internally represented as a number - you can compare whole date. In your case you probably have to use Floor() to ignore time portion of the date if exists

Lukasz