topic Re: count record?? in QlikView

count record??

narender123 — Thu, 04 Jul 2013 10:51:05 GMT

Hi Team,

I want to count prerelease_numbers where prerelease_date= date(today)-7 means prerelease_date=one week back date from today.

prerelease date is in DDMMYYYY format.

Expression:

=count({<Year={$(=Max(Year)),prerelease_date={$(=Date(Today()-1))}>}prerelease_numbers)

I have attached a sample .qvw .if possible then sort out it.

Thanks.

Narender

Re: count record??

sivarajs — Thu, 04 Jul 2013 10:55:29 GMT

count({<Year={"$(=Max(Year))"},prerelease_date={"$(=Date(Today()-1))"}>}prerelease_numbers)

Re: count record??

AbhijitBansode — Thu, 04 Jul 2013 11:57:40 GMT

Sort the data with date filed so that oldest date record at top.

Assign unique ID Value lets say 'DateID' using autonumber function to each record:

now you can use below set experssion to get records you want:

DateID = {">= $(=Max(DateID) - 7) <= $(=Max(DateID))"}

Re: count record??

narender123 — Fri, 05 Jul 2013 10:54:44 GMT

Hi Mohit,

I dont want it on max(prerelease_date).I want it on today date.becuase prerelease_date entry may be not for last 5 days.So i want calculation based on date of (today - 7).Any suggestion please??

Thanks.

Re: count record??

narender123 — Fri, 05 Jul 2013 10:56:13 GMT

Thanks. But its not working.

Any Idea??

Re: count record??

narender123 — Fri, 05 Jul 2013 10:56:48 GMT

I want it on date of (today-7).

Thanks.

Narender

Re: count record??

AbhijitBansode — Fri, 05 Jul 2013 11:04:27 GMT

if you want number on excat prior 7th day then make the change as:

DateID = {$(=Max(DateID) - 7)}

Re: count record??

Sokkorn — Fri, 05 Jul 2013 11:07:01 GMT

Hi Narendar,

Not sure you have try this yet:

Count one week back from today:

=Count({<Year={$(=Max(Year)),prerelease_date = {">=$(=Date(Today()-7),'DDMMYYYY')<=$(=Date(Today(),'DDMMYYYY'))"} >} prerelease_numbers)

Count on specific date back from today one week:

=Count({<Year={$(=Max(Year)),prerelease_date={$(=Date(Today()-1,'DDMMYYYY'))}>}prerelease_numbers)

Regards,

Sokkorn

Re: count record??

narender123 — Fri, 05 Jul 2013 11:30:36 GMT

Hi,

Thanks for reply.

Please see the attached qvw.if possible to sort out it.

Re: count record??

narender123 — Fri, 05 Jul 2013 11:31:58 GMT

Hi,

Thanks for reply.

Please see the attached qvw.if possible to sort out it.

Re: count record??

narender123 — Fri, 05 Jul 2013 12:40:40 GMT

Hi All,

Thanks for your reply.

I have solved this.

My error is due to using both year and date in same expression.

Actually Year and date not working together in same expression.

Thanks.