Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Accumulated amount up until a chosen month - Syntax set expression

Hi i have the following expression to show accumulated amount for the current year.

if i select a month it shows me the total irrespective which is good, pure accumlutation.

Sum ( {1 <FYear = {"$(=Dual(Max(fYear) &'/'& Max(fYear), Max(fYear)))"}> } Amount/$(Thousand))

what i would like to do now is have a comparison with last year (2012/2013) up until a certain period which would be the month i select from the month field.

Selection

Year 2013/2014

Month Jun

Any help would be greatly appreciated.

Best,

Brad

0 Replies