topic Re: How to calculate sum for quarterly basis in QlikView

How to calculate sum for quarterly basis

vipingarg23 — Thu, 02 Aug 2018 07:56:11 GMT

Hi Team,

Please find the dummy data as an attachment.

Requirement:

I have one dimension YearQuarter and two expression A1 and B1.

I want to calculate B1 expression in such a way that it should sum the data of A1 for 2016Q1, 2016Q2, 2016Q3, 2016Q4 and same for 2017 Quarter data. I want the B1 data as below:

YearQuarter	2016Q1	2016Q2	2016Q3	2016Q4	2017Q1	2017Q2	2017Q3	2017Q4
A1	5	7	9	13	4	18	20	22
B1				34				64

Please find the dummy data as an attachment. Can anybody give me the solution?

Thanks for your help!!!!!!!!!

Re: How to calculate sum for quarterly basis

fvelascog72 — Thu, 02 Aug 2018 08:15:56 GMT

Hi,

Create a Year Field: Left(YearQuarter,4) as Year

Then in the expression use:

If(Right(YearQuarter,2)='Q4', Before(Sum(Aggr(Sum(Data), Year)), 3,1))

Saludos

Re: How to calculate sum for quarterly basis

tresB — Thu, 02 Aug 2018 08:25:51 GMT

Try this:

If(Right(YearQuarter,1)='4', RangeSum(Before(Sum(Data), 0,4)))

Re: How to calculate sum for quarterly basis

vipingarg23 — Thu, 02 Aug 2018 08:56:39 GMT

Thanks for your help..

It is working fine.