topic Re: function inside function in QlikView

function inside function

Fri, 06 Nov 2015 09:11:28 GMT

Hi,

i have written as follows:

=count({1<[Termination Year]={"=$(=(year(today())))"}>}([Employee Number]))

this should give count of employees terminated in year=current year. But it is not giving.

Is there any wrong in function used.

sunny_talwar — Fri, 06 Nov 2015 09:15:23 GMT

Try this may be:

=Count({1<[Termination Year]={"$(=Year(Today()))"}>} [Employee Number])

Gysbert_Wassenaar — Fri, 06 Nov 2015 09:15:49 GMT

Try this: =count({1<[Termination Year]={$(=year(today()))}>} [Employee Number])

miguelbraga — Fri, 06 Nov 2015 09:19:02 GMT

Hey

I think you have the expression wrong, it should be something like this:

=count({1<[Termination Year]={$(=year(today()))} >} [Employee Number])

If you want to affect the number by selection use this:

=count({$<[Termination Year]={$(=year(today()))} >} [Employee Number])

Regards,

miguelbraga — Fri, 06 Nov 2015 09:20:05 GMT

Check also this document:

Fri, 06 Nov 2015 09:24:13 GMT

hey as per the syntax there must be "=" before the $ right? If i place = it is behaving in correctly can u tell the reason?

Fri, 06 Nov 2015 09:25:31 GMT

hey as per the syntax there must be "=" before the $ right? If i place = it is behaving in correctly can u tell the reason?

sunny_talwar — Fri, 06 Nov 2015 09:27:20 GMT

Not always. When you are equating it to a number, I don't think you need that. But if You were saying >= or <= or <> then you will need it.