Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
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
shekharnil
Contributor III
Contributor III

Hi Chanty

I have a query regarding your formula

Why are you adding 60 days to your date.

Are you creating ids with future dates??

sunny_talwar

Do you still see the red line if you remove the negative sign in front of equal?

Chanty4u
MVP
MVP
Author

yes sunny.

sunny_talwar

that is very strange, can you copy and paste the expression here. Just want to check if we have all the brackets (curly, square, parenthesis) in correct place.

Chanty4u
MVP
MVP
Author

=count({<[created Date]={'<=$(=Today()+60)'},RiskIssueStatusName={'Closed'}>} RiskIssueID)



and tried this also but no use


=Count(aggr(if(Created Date<=Today()+60 and RiskIssueStatusName<>'Closed',RiskIssueID)))