Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

how to find the sum of total in particular date

How to find the sum of total in a particular date.

Ex:

Sum of total from 19/04/2014 to 23/05/2015

pls help me friends

1 Solution

Accepted Solutions

Re: how to find the sum of total in particular date

try:

sum( {$<StartDate = {“>19/04/2014”}, EndDate = {“<23/05/2015”} >} Sales )

3 Replies
datanibbler
Esteemed Contributor

Re: how to find the sum of total in particular date

Hi Abinesh,

you want to find the total of items in a particular daterange? Do you have those ranges as fixed intervals?

If so, you could use the IntervalMatch() function to join every single date to a particular interval -> Then you could just count the items across the dimension >intervals<.

You could also do it dynamically on the GUI - that is a bit more resource-intensive, but possible: The user can select a from_date and a to_date and you count and use a set_expression specifying that the [date] be >= the from_date and <= the to_date.

HTH

Re: how to find the sum of total in particular date

try:

sum( {$<StartDate = {“>19/04/2014”}, EndDate = {“<23/05/2015”} >} Sales )

Not applicable

Re: how to find the sum of total in particular date

Thank you Robert I got the solution from you answer.

=sum({1<[year]={'>25-05-2006<=05-06-2006'}>}[Order Total])

Thia  ia I made from your answer

Community Browser