How to display Order volume (cumulative) current month/ Year

[Qlik_Bio06]

Hi,

I would like to show the order volume (sum of net value CHF accumulated) from the current year 2021 to the current month. Jan-April see screenshot

Unfortunately it shows me every month in 2021

Incoming orders: SUM ({$ <Year = {'$ (= Year (Today ()))'}>} [Net Value CHF])

Order volume: SUM ({$ <Year = {'$ (= Year (Today ()))'}>} [Net Value CHF]) cumulated

Does anyone have any tip or input on how to do that?

Many thanks for the help.

[MayilVahanan]

HI @Qlik_Bio06 

Might be, try like below

SUM ({$ <Year = {'$ (= Year (Today ()))'}, DateField={"<=$(=Date(Today(),'YourDateFormat'))"}>} [Net Value CHF])

[Qlik_Bio06]

Unfortunately does not work...

SUM ({$ <Year = {'$ (= Year (Today ()))'}, Date={"<=$(=Date(Today(),'dd.mm.yyyy'))"}>} [Net Value CHF])

[Qlik_Bio06]

Now nothing is displayed even though the syntax is correct ...

[MayilVahanan]

HI @Qlik_Bio06 

Is it possible to attach sample file?