topic Upto Present Month in QlikView

Upto Present Month

khadeer — Tue, 22 Jan 2013 06:28:33 GMT

Hi All,

I want to get the data untill selected month in that year only, my report is based on finacial month. Suppose in year 2011

if Apr --1000, may--2000, june---- 3000

reult should be apr---1000, May---3000, june--- 6000, i want write it in expression, not through accumulation.

Tue, 22 Jan 2013 06:58:13 GMT

use setanalysis expr like

sum({<year=,month={"<=$(=max(month))"}>}amount)

Tue, 22 Jan 2013 07:01:48 GMT

above(sum(amount))

Tue, 22 Jan 2013 07:03:42 GMT

rangesum(above(sun(amount)))

er_mohit — Tue, 22 Jan 2013 07:12:02 GMT

hii

try this in expression

rangesum(above(sum(fieldname),0,rowno()))

sivarajs — Tue, 22 Jan 2013 07:29:27 GMT

This might helps you