Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

>Today, AND, OR Condition in set analysis

Hello,

I need a set analysis expression for a condition but unable to accomplish it.

count( if (Code is not null) and (EndDate is null or greater than today))

I would appreciate if anyone can help me on this.

1 Solution

Accepted Solutions
Highlighted

May be something like this:

Count({<Code = {"=Len(Trim(Code)) > 0"}, EndDate = {"=Len(Trim(EndDate)) = 0"}+{"$(='>' & Date(Today(), 'YourEndDateFormatHere'))"}>} FieldYouAreCountingHere)

View solution in original post

3 Replies
Highlighted

May be something like this:

Count({<Code = {"=Len(Trim(Code)) > 0"}, EndDate = {"=Len(Trim(EndDate)) = 0"}+{"$(='>' & Date(Today(), 'YourEndDateFormatHere'))"}>} FieldYouAreCountingHere)

View solution in original post

Highlighted
Partner
Partner

Looks Perfect. Thanks a lot

Highlighted
Master III
Master III

sunindia

Salute to you Boss....