topic RE:Date -issue in QlikView

RE:Date -issue

Chanty4u — Wed, 30 Mar 2016 15:29:53 GMT

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

Re: RE:Date -issue

sunny_talwar — Wed, 30 Mar 2016 15:35:46 GMT

May be this:

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

Re: RE:Date -issue

Kushal_Chawda — Wed, 30 Mar 2016 15:41:01 GMT

if is missing i think

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

Re: RE:Date -issue

Chanty4u — Wed, 30 Mar 2016 16:37:53 GMT

Not working bro.

Re: RE:Date -issue

Chanty4u — Wed, 30 Mar 2016 16:38:16 GMT

Not working bro.

Re: RE:Date -issue

sunny_talwar — Wed, 30 Mar 2016 16:39:06 GMT

Not working and yet you are so happy .

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

Re: RE:Date -issue

Chanty4u — Wed, 30 Mar 2016 16:44:09 GMT

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

Re: RE:Date -issue

sunny_talwar — Wed, 30 Mar 2016 16:45:37 GMT

Then how are we going to help you bro?

Re: RE:Date -issue

Chanty4u — Wed, 30 Mar 2016 16:50:27 GMT

hi kush,

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

Re: RE:Date -issue

Chanty4u — Wed, 30 Mar 2016 16:50:47 GMT

this expression giving error.

Re: RE:Date -issue

sunny_talwar — Wed, 30 Mar 2016 16:56:18 GMT

What about this:

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

Re: RE:Date -issue

Kushal_Chawda — Wed, 30 Mar 2016 17:00:14 GMT

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

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

Re: RE:Date -issue

tamilarasu — Wed, 30 Mar 2016 17:02:41 GMT

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

Re: RE:Date -issue

sunny_talwar — Wed, 30 Mar 2016 17:04:56 GMT

I did add them back above

Suresh is the one who forgot first

Re: RE:Date -issue

Chanty4u — Wed, 30 Mar 2016 17:07:12 GMT

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

you guys were found the issues. to help me

Re: RE:Date -issue

Chanty4u — Wed, 30 Mar 2016 17:07:49 GMT

I'll try and let u know all.

Re: RE:Date -issue

tamilarasu — Wed, 30 Mar 2016 17:07:58 GMT

I mean single quote after Today()+60.

Re: RE:Date -issue

sunny_talwar — Wed, 30 Mar 2016 17:08:41 GMT

How long have you been using QlikView Suresh?

Re: RE:Date -issue

sunny_talwar — Wed, 30 Mar 2016 17:09:50 GMT

Sorry, that I did not realize.

Thanks for pointing that out

Re: RE:Date -issue

Chanty4u — Wed, 30 Mar 2016 17:10:02 GMT

thnx Raj.

i will try and let u know.