topic Re: help with expression in QlikView

help with expression

aaronnayan — Wed, 25 Nov 2020 16:16:04 GMT

Can someone help me with this

I want to find the sales of desk_table for the current month in qlik

=Money(sum(Month(Today())[desk_table]))

ahaahaaha — Tue, 20 Jun 2017 14:43:52 GMT

Try

Money(sum({<Month={"=Month(Today())"}>}[desk_table]))

aaronnayan — Tue, 20 Jun 2017 14:46:31 GMT

sorry andrey thats totalling all the months

if it helps i have made a variable for the current month vCurrent_Month

sunny_talwar — Tue, 20 Jun 2017 14:50:47 GMT

I think you forgot the dollar sign expansion.

Money(sum({<Month={"$(=Month(Today()))"}>}[desk_table]))

and may be you need year as well

Money(sum({<Month={"$(=Month(Today()))"}, Year = {"$(=Year(Today()))"}>}[desk_table]))