Solved: Re: RE:Date -issue - Qlik Community

Chanty4u · ‎2016-03-30

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))

tamilarasu · ‎2016-03-30

@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

sunny_talwar · ‎2016-03-30

May be this:

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

Kushal_Chawda · ‎2016-03-30

if is missing i think

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

Chanty4u · ‎2016-03-30

Not working bro.

Chanty4u · ‎2016-03-30

Not working bro.

sunny_talwar · ‎2016-03-30

Not working and yet you are so happy .

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

Chanty4u · ‎2016-03-30

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

sunny_talwar · ‎2016-03-30

Then how are we going to help you bro?

Chanty4u · ‎2016-03-30

hi kush,

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

Chanty4u · ‎2016-03-30

this expression giving error.