Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
khadeer
Specialist
Specialist

Upto Present Month

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.

5 Replies
Not applicable

Hi

use setanalysis expr like

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

Not applicable

above(sum(amount))

Not applicable

rangesum(above(sun(amount)))

er_mohit
Master II
Master II

hii

try this in expression

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

sivarajs
Specialist II
Specialist II

This might helps you