# QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

## I want to Sum the value from one date to another date

Hi friends,

I wanna to sum the range of values from one date to another date.

Abinesh.S

1 Solution

Accepted Solutions
Contributor

## Re: I want to Sum the value from one date to another date

If u want to do it with out variable using a hardcore date, then

=sum({<Date={">=('01-01-2015')<=('05-01-2015')"}>}Sales)

7 Replies
Contributor

## Re: I want to Sum the value from one date to another date

Hi,

R u giving a selection range for date. like from date and to date....can u post a sample

Not applicable

## Re: I want to Sum the value from one date to another date

This is my table I need to show the sum of Billing day from 01-01-2015 to 05-01-2015.

And am using this Exp "=sum({\$<Date={'01-01-2015','05-01-2015'}>} [Billing day]) " for that but I doesn't provide the exact result what I need.

I don't know how to get that value........

Not applicable

## Re: I want to Sum the value from one date to another date

And one more thing in the above exp I got result "2" because it consider the dates value only whatever I highlighted in that exp

Contributor

## Re: I want to Sum the value from one date to another date

For this create two variables in which it stores your start date and end date. Then use this expression:.,

=sum({<Date={">=\$(vStartDate)<=\$(vEndDate)"}>}Sales)

Contributor

## Re: I want to Sum the value from one date to another date

If u want to do it with out variable using a hardcore date, then

=sum({<Date={">=('01-01-2015')<=('05-01-2015')"}>}Sales)

MVP

## Re: I want to Sum the value from one date to another date

Hi Abinesh,

Based on the requirement you can use ,if condition or set analysis to get the count.

Valued Contributor III

## Re: I want to Sum the value from one date to another date

Hi

If you need result on particular Date than Try this:

=sum({<Date={">=\$(='01/01/2015')<=\$(='05/01/2015')"}>}[Blling day])

Regards

Av7eN