topic use function in exclude part of expression in QlikView

use function in exclude part of expression

Fri, 22 Jul 2016 09:12:53 GMT

Heloo for all,

I would like to help me with my problem. The following expression does not work and dont know why?

count({1<[Month-Year] =- {month(now())&'-'&year(now())}>}CountRow)

[Month-Year] contains January-2016, February-2016,...and I need to use expression and not the exact value

count({1<[Month-Year] =- {'January-2016'}>}CountRow)

This works fine. How could I write into {} that is the function and need to calculated and convert to string?

Thank you in advance.

Regards,

Peter

Re: use function in exclude part of expression

swuehl — Fri, 22 Jul 2016 11:05:54 GMT

Try

{'$(=Date(Now(),'MMMM-YYYY'))'}

Re: use function in exclude part of expression

sunny_talwar — Fri, 22 Jul 2016 11:19:11 GMT

How about this:

Count({1<[Month-Year] =- {'$(=Text(Date(Now(), 'MMMM')), & '-' & Year(Now()))'}>} CountRow)

Re: use function in exclude part of expression

susovan — Fri, 22 Jul 2016 11:34:20 GMT

Try this,

count({1<[Month-Year] -= {month(now())&'-'&year(now())}>}CountRow)

Re: use function in exclude part of expression

michael_anthony — Sun, 24 Jul 2016 23:42:07 GMT

I would advise against using Now() as that constantly re-evaluates so the expression will have to recalculate itself repeatedly. Today() might be better.

Re: use function in exclude part of expression

Mon, 25 Jul 2016 07:01:52 GMT

not working...

Re: use function in exclude part of expression

Mon, 25 Jul 2016 07:12:14 GMT

This is working.....

Count({1<[Month-Year] =- {'$(=Text(Date(Now(), 'MMMM'))& '-' & Year(Now()))'}>} CountRow)

I have to delete the comma after double bracket )) and now works fine

Re: use function in exclude part of expression

Mon, 25 Jul 2016 07:13:09 GMT

Thanks it seems to be good idea and now includes in the formula