topic Re: Sum between two dates in QlikView

Sum between two dates

zied_ahmed1 — Fri, 09 Sep 2016 09:19:55 GMT

Hi,

I´m having some problems trying to have the value between two different time periods selected by the user.

For example if I choose a first periode : (17/02/2013 and date 17/02/2013) and a second periode : ( (17/03/2013 and date 17/04/2013) ) i will have the value of sales between these two periodes

How to fix it please

Re: Sum between two dates

neelamsaroha157 — Fri, 09 Sep 2016 15:37:06 GMT

You can create two variables for the start Input Date and End Input date and then use the

Sum(({<Date ={">=$(vStartDate)<=$(vEndDate)"}>}, Measure) in your calculation.

Hope this helps

Re: Sum between two dates

miguelbraga — Fri, 09 Sep 2016 15:38:58 GMT

Hey there,

Can you provide some sample data? And/or provide a better explanation of your problem?

Regards,

Re: Sum between two dates

MindaugasBacius — Fri, 09 Sep 2016 15:50:08 GMT

I guess you have one calendar or Date field. If I am right than your database should look like table object below:

And your expression would be:

=sum(
{$<
  Date = {">=$(=min(Date))<=$(=max(Date))"}
>}
Value)

Check the application I've attached.

Re: Sum between two dates

neelamsaroha157 — Fri, 09 Sep 2016 16:03:50 GMT

Here is the attachment..Hope this helps..

Re: Sum between two dates

miguelbraga — Fri, 09 Sep 2016 16:30:11 GMT

Is this what you want?

Regards,

Re: Sum between two dates

Fri, 09 Sep 2016 19:27:00 GMT

Sum(({<Date ={">=$(vfirstStartDate)<=$(vfirstEndDate)"}>}, sales) +

Sum(({<Date ={">=$(vsecondStartDate)<=$(vsecondEndDate)"}>},sales)