topic Re: Last 15 days data from max selection day. in QlikView

Last 15 days data from max selection day.

sona_sa — Tue, 23 Jun 2015 07:31:14 GMT

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.

Re: Last 15 days data from max selection day.

lironbaram — Tue, 23 Jun 2015 07:53:31 GMT

attach is an example

this example uses set analysis to calculate the date range

hope it helps you

Re: Last 15 days data from max selection day.

sona_sa — Tue, 23 Jun 2015 08:08:23 GMT

Hi Liron,

This is good, But my requirement is like, Suppose I select 22 June then in Line graph object data should to represent till 22nd June not for 23 June. From 8th June to 22nd June.

If I select 21st June - then 7th June to 21st June.

Thanks for quick response.

Re: Last 15 days data from max selection day.

jagan — Tue, 23 Jun 2015 08:15:39 GMT

Hi,

Try this

Max({<CDay=,CMonth=,CYear=,CDate={">=$(=date(max(CDate)-14,'dd-MMM-yy'))<=$(=date(max(CDate),'dd-MMM-yy'))"}>}Aggr(Sum({<CDay=,CMonth=,CYear=,CDate={">=$(=date(max(CDate)-14,'dd-MMM-yy'))<=$(=date(max(CDate),'dd-MMM-yy'))"}>}NoOfUsers),Name,CaptureDtTime))

Re: Last 15 days data from max selection day.

lironbaram — Tue, 23 Jun 2015 08:28:37 GMT

yes you are right

forgot to add the end period argument

have a look at this version

Re: Last 15 days data from max selection day.

sona_sa — Tue, 23 Jun 2015 09:22:43 GMT

Hi Jagan,

Thanks for reply, Now it is ok for this this expression. But I am getting fail when I am adding one more expression on the same object. Where I am adding No. of License. There will be always one selected value on Instance (Name) field.

Till time it is ok.

Now when I am selecting a date, Last 15 days data is represent but for No. of license. it is not geeting the line. !

Also for all instance there is correct value, But for Vietnam I want vice - versa output of no. of license. It will go from 70 to 30 not from 30 to 70.

For more ref. Please find the attached qvw.

Thanks.

Re: Last 15 days data from max selection day.

sona_sa — Tue, 23 Jun 2015 09:24:26 GMT

Thanks Liron.

Hi Liron,

Till time it is ok.

Now when I am selecting a date, Last 15 days data is represent but for No. of license. it is not geeting the line. !

Also for all instance there is correct value, But for Vietnam I want vice - versa output of no. of license. It will go from 70 to 30 not from 30 to 70.

For more ref. Please find the attached qvw.

Thanks.

Re: Last 15 days data from max selection day.

jagan — Tue, 23 Jun 2015 09:46:12 GMT

Hi,

Try this in No. of Licenses expression

Sum({<CDay=,CMonth=,CYear=,CDate={">=$(=date(max(CDate)-14,'dd-MMM-yy'))<=$(=date(max(CDate),'dd-MMM-yy'))"}>} Aggr(if(CDate <=max(date(LicenseDeployDate)),MinNoOfLicense,MaxNoOfLicense), NavisionInstance, CDate))

Regards,

jagan.

Re: Last 15 days data from max selection day.

lironbaram — Tue, 23 Jun 2015 09:54:14 GMT

not sure

this exactly what you meant

but have a look at this

Re: Last 15 days data from max selection day.

sona_sa — Wed, 24 Jun 2015 05:52:13 GMT

Hi Liron,

Thanks for reply. It is very very helpful for me. But I was just assuming suppose on the behalf of hard coding of 14 if we pass the variable and whatever we will put in input box, it will show according to inputbox number.

But by default it will show 15 days data.

Please refer the attached qvw.

Thanks.

Re: Last 15 days data from max selection day.

jagan — Wed, 24 Jun 2015 14:26:41 GMT

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.