topic Re: how to sum measurement between dates in QlikView

how to sum measurement between dates

Thu, 06 Jun 2013 07:56:48 GMT

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

Re: how to sum measurement between dates

sushil353 — Thu, 06 Jun 2013 08:03:29 GMT

Post some sample data or application.

Re: how to sum measurement between dates

Thu, 06 Jun 2013 08:25:36 GMT

sorry what should i look exactly ?

Re: how to sum measurement between dates

Thu, 06 Jun 2013 09:09:57 GMT

where is the file ?

Re: how to sum measurement between dates

Thu, 06 Jun 2013 09:10:21 GMT

i got it

Re: how to sum measurement between dates

Thu, 06 Jun 2013 09:13:58 GMT

where do you use sum in range date ?

Re: how to sum measurement between dates

Thu, 06 Jun 2013 10:07:06 GMT

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.

Re: how to sum measurement between dates

Thu, 06 Jun 2013 10:26:45 GMT

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

Re: how to sum measurement between dates

er_mohit — Thu, 06 Jun 2013 10:39:42 GMT

See the attached File

in another tab

Re: how to sum measurement between dates

Thu, 06 Jun 2013 11:22:55 GMT

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.

Re: how to sum measurement between dates

Thu, 06 Jun 2013 13:08:53 GMT

Hey Mohit,

First, thank you for your quick responce. I was looking at your script and would like to understand what were you doing with Sales_ID or Cust_id etc on Main_2 tab. Is this tab is a part of this example?.

Sorry for asking. Since im new and trying to understand your logic.

Re: how to sum measurement between dates

Thu, 06 Jun 2013 13:16:17 GMT

Again Thank you for your smoking fast responce.

Re: how to sum measurement between dates

Thu, 06 Jun 2013 15:04:31 GMT

but how it know to select 12 months