Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Creator II
Creator II

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
Highlighted
Creator II
Creator II

Hi,

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

Highlighted
Not applicable

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........

Highlighted
Not applicable

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

Highlighted
Creator II
Creator II

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
Creator II
Creator II

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

Highlighted

Hi Abinesh,

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

Highlighted
Specialist III
Specialist III

Hi

If you need result on particular Date than Try this:

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

Regards

Av7eN