RE:Date -issue

[Chanty4u]

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

[sunny_talwar]

What about this:

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

[Kushal_Chawda]

I think you don;t need aggr function just try below

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

[tamilarasu · Accepted solution]

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

[sunny_talwar]

I did add them back above

Suresh is the one who forgot first

[Chanty4u]

dont involve  me bro....Am just learner  ...so usually i do mistakes....

you guys  were found the issues.  to help me

[Chanty4u]

I'll  try and let  u know all. 

[tamilarasu]

I mean single quote after Today()+60.

[sunny_talwar]

How long have you been using QlikView Suresh?

[sunny_talwar]

Sorry, that I did not realize.

Thanks for pointing that out

[Chanty4u]

thnx  Raj.

i will try and let u know.