Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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.