Last 15 days data from max selection day.

[sona_sa]

Hello Friends,

I have a line chart object where I am representing last 15 days Max No. of User login. Now when I select a month, for example - June.

By default it is representing from 23 Jun to Previous 15 days record. Now If I select 22 June, Object representing one day data.

Selection Day is 22 Jun - Then from 8th Jun till 22nd Jun. Suppose I select 10th Jun then from 26th May till 10th June data should to represent in line chart object

I need whatever day, I select it should represent last 15 days data from the selection of max day.

For more ref. Please find the attached QV file.

Thanks.

[jagan]

HI,

In your expressions just replace 14 with vInputNumber like below

sum({<CDay=,CMonth=,CYear=,CDate={">=$(=date(max(CDate)-vInputNumber,'dd-MMM-yy')) <=$(=date(max(CDate),'dd-MMM-yy'))"}>}

  aggr(if(max({<CDay=,CMonth=,CYear=,CDate={">=$(=date(max(CDate)-vInputNumber,'dd-MMM-yy'))"}>}CDate)<=

  max({<CDay=,CMonth=,CYear=>}LicenseDeployDate),max({1}MinNoOfLicense),max({1}MaxNoOfLicense)),NavisionInstance,CDate))

If you got the answer close this thread by giving correct and helpful answers to the helpful posts.

Regards,

Jagan.