Qlik Community

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.

Like sum of values from 01-05-2015 to 12-05-2015. Please help me

Thanks in advance

    Abinesh.S

1 Solution

Accepted Solutions
Highlighted
help4qv123
Contributor II

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)

View solution in original post

7 Replies
help4qv123
Contributor II

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

Billing.PNG

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

help4qv123
Contributor II

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)

Where vStartDate=Your start date

vEndDate= Your end date

Highlighted
help4qv123
Contributor II

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)

View solution in original post

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.

aveeeeeee7en
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