Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Greater than date in set analysis

Hi,

We have the following expression:

=count({<[MonthYear2]={">=$(vPreviousMonth4.))"}>}TaskId)

This doesnt work.

The variable is as following:

Let vPreviousMonth4. = text(date(addmonths(date(Now()),-4),'M-YYYY'));

When we write the expression as the following:

=count({<[MonthYear2]={"$(vPreviousMonth4.))"}>}TaskId), it shows us all of Nov 15 only. However when we say greater than, it shows nothing.


Help please.


Thanks.

1 Solution

Accepted Solutions
sunny_talwar

Is MonthYear2 a text field? You are using text in your variable, so I am guessing MonthYear2 is text. If it truely is text field, then I am not sure how are you hoping to find greater or less than of a text field?

View solution in original post

5 Replies
sunny_talwar

Is MonthYear2 a text field? You are using text in your variable, so I am guessing MonthYear2 is text. If it truely is text field, then I am not sure how are you hoping to find greater or less than of a text field?

hic
Former Employee
Former Employee

I think you have a bracket too much.

  count({<[MonthYear2]={"$(vPreviousMonth4.))"}>}TaskId)

See also Dates in Set Analysis

HIC

Anonymous
Not applicable
Author

I  agree  with Henric Cronström,  your  expression have  one  bracket  of more.

=count({<[MonthYear2]={">=$(vPreviousMonth4.)"}>}TaskId)

Regards

engishfaque
Specialist III
Specialist III

Dear Sharandeep,

This expression is working fine to me,

=Count({<[MonthYear2]={">=$(vPreviousMonth4.)"}>}TaskId)

Kind regards,

Ishfaque Ahmed

Not applicable
Author

Very true. Thank you