topic Re: How can I heap in a second dimension? in QlikView

How can I heap in a second dimension?

Thu, 31 Jul 2014 12:25:14 GMT

Hi, everyone!

I need to solve this problem and can't think of a solution.

I have this graph:

I need to heap the second quarter (2ºTri/2010) plus first (when user select first and second quarter, I need to heap the sales - in this case, 12.275 in the first quarter and 12.275 + 12.504 in the second quarter). There's the option "Accumulation" in the "Expression" tab, but when I select this option, it's heap by Administrator (Administradora), like this:

The definiton of this expression is: "=SUM(QTD_COTAS_SUBSCRITAS)"

Dimensions: Nome_Administradora_UF (name of administrator) and trimestreAno_BC (quarter and year)

Can someone help me?

Re: How can I heap in a second dimension?

Thu, 31 Jul 2014 12:49:52 GMT

If you have only 2 values in 2nd dimension, try to put something like

=SUM(QTD_COTAS_SUBSCRITAS)+Alt(Above(SUM(QTD_COTAS_SUBSCRITAS)),0)

Will not work with more values.

Re: How can I heap in a second dimension?

Thu, 31 Jul 2014 12:55:14 GMT

Yeah, it works fine! But I really need it to, at least, 4 values (1st, 2nd, 3rd and 4th quarter in a year)!

Re: How can I heap in a second dimension?

Thu, 31 Jul 2014 13:26:05 GMT

RangeSum(Above(SUM(QTD_COTAS_SUBSCRITAS),0,4))

for your 4 quarters

Re: How can I heap in a second dimension?

Thu, 31 Jul 2014 13:40:12 GMT

It works!

Just a correction: RangeSum(Above(SUM(QTD_COTAS_SUBSCRITAS),1,4)).

In my case, I put "SUM(QTD_COTAS_SUBSCRITAS) + RangeSum(Above(SUM(QTD_COTAS_SUBSCRITAS),1,4))"

and works. With 0, gets some wrong values.

But really, really thanks!