Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

use function in exclude part of expression

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

1 Solution

Accepted Solutions
sunny_talwar

How about this:

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

View solution in original post

7 Replies
swuehl
MVP
MVP

Try

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

sunny_talwar

How about this:

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

View solution in original post

susovan_g
Partner
Partner

Try this,

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

michael_anthony
Creator II
Creator II

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

Not applicable
Author

not working...

Not applicable
Author

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

Not applicable
Author

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