Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Text Field to show value for current month & year

As simple as =sum([Invoice Value]) for the total value, but i need this for the current month/year.

I can easily acomplish this by using the Actions (Select in field =month(vToday) and =year(vToday))

but i would like for this value to display automatically, like i have for value such as pending quotes etc (=sum({<[Quote Status]={'Pending'}>}[Quote Amount]))

Is this possible to do?

1 Solution

Accepted Solutions
jonathandienst
Partner - Champion III
Partner - Champion III

Hi

This hould do it

sum({<Month={"$(=Month(vToday))"}, Year={"$(=Year(vToday))"}>} [Invoice Value])

Regards

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

3 Replies
rajni_batra
Specialist
Specialist

=sum({<month={"$(=vMonth)"}, year={"$(=vYear)"}>}, invoice Value)

where

vMonth=month(today())

vYear=year(today())

Try this

jonathandienst
Partner - Champion III
Partner - Champion III

Hi

This hould do it

sum({<Month={"$(=Month(vToday))"}, Year={"$(=Year(vToday))"}>} [Invoice Value])

Regards

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable
Author

Thanks Jonathan