topic Re: calculate per year in QlikView

calculate per year

Tue, 03 Nov 2015 12:48:20 GMT

Hello guys!

I actually need help with some calculating in my application

i have values like TOTAL, YEAR AND CARLABLE

how can i calc the total value of the carlable per year

thanks for helping

Anonymous — Tue, 03 Nov 2015 16:10:54 GMT

I guess you can use a simple pivot table chart with Year and Carlabel as dimensions and sum(Total) as expression

santiago_respane — Tue, 03 Nov 2015 18:42:46 GMT

Hi Diar,

i would go with Oscar's sugestion but if you want the calculation to be done in the loading script you should use something like this:

Table1:

load Col1, Col2,Col3

from ...somewhere...;

join(Table1)

load sum(Col3)

resident Table1

Group by Col1,Col2;

Hope this helps.

Regards,

jolivares — Tue, 03 Nov 2015 19:33:37 GMT

Sum(Total <Ar> Totalt)

Wed, 04 Nov 2015 12:22:53 GMT

actually my question was little confusing, i want to calc the Totalt table value per year per carlabel, not only per year.

Wed, 04 Nov 2015 12:26:15 GMT

actually my question was little confusing, i want to calc the Totalt table value per year per carlabel, not only per year.

jolivares — Wed, 04 Nov 2015 12:55:50 GMT

Sum(Total <Ar,Marke> Totalt),

Sum(Aggr(Sum(Totalt),Ar,Marke))