Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
See why Qlik was recognized for the seventh year in a row – and discover how we can help you tackle your data integration challenges. Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Sum Period + Sum Previus Period

Hi,

I Have a chart with 3 colums, period, product, sum(qty)

and one list box with period.

This work perfect, now need add a column whit the sum of qty of previus period for each product.

Any idea?

Thanks Regards

César Estrada

1 Solution

Accepted Solutions
Not applicable
Author

Hi, Thanks both, the formula that work for me is

= sum({<Period= {">=1(=min(Period))<=$(=max(Period)-1)"}> } qty)

Thanks Regards

View solution in original post

5 Replies
robert_mika
Master III
Master III

Try

above(sum(qty))

renjithpl
Specialist
Specialist

may be like this,

Sum {<Period = {"$(=(MAX(Period)-1))"}>}qty)

Not applicable
Author

Hi Renjith, when paste u formula suggested, on the expression, tell me "garbage after expression", i cant use u formula on a expression or is for another use

Thanks

Not applicable
Author

Hi Robert,

I try for example, sum between 2014 jan to 2015 jan, for each product and show this in one column, and 2015 feb in another column.

When chose 201502 in the list box, sum only 201502, but de another sum is 0.

U can please make one example for me

Regards

César Estrada

Not applicable
Author

Hi, Thanks both, the formula that work for me is

= sum({<Period= {">=1(=min(Period))<=$(=max(Period)-1)"}> } qty)

Thanks Regards