Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP 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))

1 Solution

Accepted Solutions
tamilarasu
Champion
Champion

@Suresh

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


@ Sunny You forgot to add single quote.

=Count({<[Created Date] = {'<=$(=Today()+60)'}, StatusName -= {'Closed'}>} IssueID)

View solution in original post

34 Replies
sunny_talwar

May be this:

=Count({<Created Date = {'<=$(=Today()+60)}, StatusName -= {'Closed'}>} IssueID)

Kushal_Chawda

if is missing i think

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

Chanty4u
MVP
MVP
Author

Not working bro.

Chanty4u
MVP
MVP
Author

Not working bro.

sunny_talwar

Not working and yet you are so happy .

You know my next question to you, don't you? Sample?

Chanty4u
MVP
MVP
Author

yes i know.dats y  i given smily...... it means no sample

sunny_talwar

Then how are we going to help you bro?

Chanty4u
MVP
MVP
Author

hi kush,


this one is not showing correct value...it's calculating sum of id's.

Chanty4u
MVP
MVP
Author

this expression giving error.