topic Re: Text Field to show value for current month & year in QlikView

Text Field to show value for current month & year

Mon, 17 Sep 2012 11:26:58 GMT

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?

Re: Text Field to show value for current month & year

rajni_batra — Mon, 17 Sep 2012 11:30:43 GMT

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

where

vMonth=month(today())

vYear=year(today())

Try this

Re: Text Field to show value for current month & year

jonathandienst — Mon, 17 Sep 2012 11:37:03 GMT

This hould do it

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

Regards

Jonathan

Re: Text Field to show value for current month & year

Mon, 17 Sep 2012 12:05:01 GMT

Thanks Jonathan