Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to sum measurement between dates

Hi

I have to dates ( from , to)

I want to add a calculate column to a table that , sum the measurement  from date to date

for example :

my table present 04.2013 data

i have to variable (04.2013 and 05.2012)

i want to present column that sum the the measurement for all 12 month .

how do i do it ?

thank you

12 Replies
sushil353
Master II
Master II

Post some sample data or application.

Not applicable
Author

hi

sorry what should i look exactly ?

Not applicable
Author

where is the file ?

Not applicable
Author

i got it

Not applicable
Author

where do you use sum in range date ?

Not applicable
Author

if i am reffering t your example

i want to select FEB-2013

and i want to present :sum sale from MAR-2012 to FEB-2013

how do i it ?

let assume i have these two dates in varibales.

Not applicable
Author

hi

sorry

i probably misunderstood:

when i  select FEB-2013

then i want to present in a table two columns like this:

"Sale currnet month - FEB-2013" =  257

"Sale Total 12 mothes"   = 3018

thank you

er_mohit
Master II
Master II

See the attached File

in another tab

Not applicable
Author

hi

first thank you that is what i mean

i look at your code

i turn the graph into table

and i don't understant how the sale column know to sum 12 months from the current select month.