Problems with time interval month

[#1]

Hello everyone,

little problem with a formula

Sheet "Sales Report"

Object "Budget"

Last column

I want to calculate the% increase in 2015 vs. 2014 but the same period.

The interval must be selected every month and in 2013, 2014 and 2015.

I want the value in%, for example, today April the ratio between January February March 2015 versus January February March 2014 .... and so on   ...   in May the ratio of January February March April 2015 versus January February March April 2014

Someone can help?

I attach files.

Thank You.

Gian Paolo

[ramoncova06]

add into your script a regular date format and then create a variable that reads your max and min date and add that into your set analysis  

sum({<FV_Tipo=,YearMonthDate = {'>=$(=(vMinCurrentDate))<=$(=(vMaxCurrentDate))'},>} FV_Imponibile)

this document should help also

QlikView App: Dates, Date Ranges and Set Analysis

[#3]

Hi Ramon,

thanks but don't work ...

Please you can enter a formula in my example?

Thanks again ....

Gian Paolo

[ramoncova06]

I misunderstood your requirement, you are already doing what I was suggesting

but have you tried using the column number identifier, instead of your current formula ?

this is the expression

(rangesum(above(column(1)&' ' ,0,12)))

/

rangesum(above(column(2),0,12))

and this is the result

Mese	2015	2014	Diff	Diff %	New Metric
	€ 129097.90	€ 241611.70	-€ 112513.80	+53.4%	53.43%
gen	€ 56650.00	€ 147613.70	-€ 90963.70	+38.4%	38.38%
feb	€ 87132.90	€ 219006.70	-€ 131873.80	+42.7%	39.79%
mar	€ 129097.90	€ 241611.70	-€ 112513.80	+185.6%	53.43%

[#5]

Hi Ramon,

sorry but I explained bad ... we try again.

Sheet "Sales Report"

Object "Budget"

Last column

I select all of 2013, 2014 and 2015.

In the last column I want the following result.

Today we are in April and I would like the difference in % of sales between the months of January February March 2015 VS January February March 2014.

In May I would like the difference in % of sales between the months of January February March April 2015 VS January February March April2014.

Thanks.

Gian Paolo

[ramoncova06]

‌what do you expect to see in Jan?

[#7]

Hi Ramon,

look this formula:

(rangesum(above(sum({<FV_Tipo=, Anno={$(vMaxAnno)}>} FV_Imponibile),0,12)) - rangesum(above(sum({<FV_Tipo=, Anno={$(vMaxAnnoPrec)}>} FV_Imponibile),0,12)))  /  rangesum(above(sum({<FV_Tipo=, Anno={$(vMaxAnnoPrec)}>} FV_Imponibile),0,12))

Is almost correct but I want today April I make a comparison between the first three months of 2015 versus the first three months of 2014.

As it is now compares the first 3 months of 2015 with the end of 2014 and it is not what I want.

it is clear ... thanks

Gian Paolo

[#8]

Hi Ramon .....

or better the formula works if I enter dimension "MONTH" and I become the first.

But if I enter this dimension "MONTH"  throughout the grid changes and it is not what I want.

Thank You.

Gian Paolo

[ramoncova06]

so i replaced the accumulation calculation that was being done in the first two columns with your expression and then applied the formula that I believe you wanted to add in

attached is the document

thanks

[#10]

Hi Ramon,

I saw that you made changes to the object "Sales Report" of the sheet "Sales Report".

But that's okay.

The last column

I want to change the last column of the grid the object's Budget in the sheet "Sales Report".

OK?

Thanks