count record??

[narender123]

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

[sivarajs]

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

[AbhijitBansode]

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

[narender123]

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.

[narender123]

Thanks. But its not working.

Any Idea??

[narender123]

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

Thanks.

Narender

[AbhijitBansode]

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

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

[Sokkorn]

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

[narender123]

Hi,

Thanks for reply.

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

[narender123]

Hi,

Thanks for reply.

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