Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

sureshqv
Esteemed Contributor III

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 DimensionSmiley SadIssue 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

Re: RE:Date -issue

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

34 Replies

Re: RE:Date -issue

May be this:

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

Re: RE:Date -issue

if is missing i think

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

sureshqv
Esteemed Contributor III

Re: RE:Date -issue

Not working bro.

sureshqv
Esteemed Contributor III

Re: RE:Date -issue

Not working bro.

Re: RE:Date -issue

Not working and yet you are so happy .

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

sureshqv
Esteemed Contributor III

Re: RE:Date -issue

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

Re: RE:Date -issue

Then how are we going to help you bro?

sureshqv
Esteemed Contributor III

Re: RE:Date -issue

hi kush,


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

sureshqv
Esteemed Contributor III

Re: RE:Date -issue

this expression giving error.

Community Browser