Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Chanty4u
MVP
MVP

RE:Date -issue

Hi all,

I'm facing an issue in the chart(Combo). I need to display Open/Closed/Raised Issues from (01-Jan-16 to 29-Feb-16) between the period. Feb-16 showing correct Number(612)..But Jan-16 is not correct.

Taken Dimension:(Issue Month consist ->  Jan-16 & Feb-16).

Created Date is field used in expression.

this exp am using right now

=Count(Aggr(Created Date<=Today()+60 and StatusName<>'Closed',IssueID))

34 Replies
tamilarasu
Champion
Champion

No worries. I just checking this thread alone in my mobile. Bye guys.

sunny_talwar

Using the new iPhone App?

Chanty4u
MVP
MVP
Author

yes worries only raj   

the error is comig where  -={'closed}

sunny_talwar

Are you using a old version of QlikView? Expression editor used to show error with the negative sign in front of the equal sign.

Also make sure you have closing single quote at the end of Close

-={'closed'}

tamilarasu
Champion
Champion

No Sunny. I'm using android mobile. I have to check it from someone's phone.

Chanty4u
MVP
MVP
Author

no sunny..

i missed here.... but not in expression........

sunny_talwar

Version of QV?

Chanty4u
MVP
MVP
Author

11 bro

Chanty4u
MVP
MVP
Author

hi sunny,

chk below.

error message

is it possible to create  dynamic  dates?

iss-1.PNGisue-2.PNG

Chanty4u
MVP
MVP
Author

Hi sunny,

Did u chk the imgaes?

which following the error?