topic Error in the qlikview expression in QlikView

Error in the qlikview expression

Wed, 14 Jun 2017 12:56:36 GMT

I created a variable and added the below expression, somehow it isn't giving all the distinct sso's what I needed.

Variable1=concat({$<[Last Login Date]={"$(today()-30)"}> DISTINCT SSO,';')

Basically I wanted those sso's where today()-Last Login Date] >=30

Once the above condition satisfies, it will sent mail to only those sso's in the organization.

='mailto:'&Variable1&' & ?subject = Report Last Used '&[Last Login Date]&'

Let me know your thoughts?

Wed, 14 Jun 2017 15:38:32 GMT

Try this Put "$( )" around your reference to Variable 1 as shown below:

='mailto:'& $(Variable1) &' & ?subject = Report Last Used '&[Last Login Date]&'

You might also want to change "today()" to "today(1)" in your variable so that it picks up the current date... if that's what you're after.

Also, make sure that your variable content doesn't start with "=".

Wed, 14 Jun 2017 16:34:28 GMT

Let me try that but I think my variable expression is also wrong, it is not giving me the list of ssoid

concat({$<[Last Login Date]={"$(today()-30)"}> DISTINCT SSO,';')

I am trying to take only those SSO's if Today() - Last Login Date > 30