topic Re: issue in current month in QlikView

issue in current month

soniasweety — Sat, 16 Nov 2024 00:00:23 GMT

Hi all,

im using text object to show the max month data .

and using below expression not working.

YearMonth = 2020-Jul, 2020-Aug

when open the dashboard i want to see max month data text object and it should show based on yea month selection it should chnge.

tried below exp: count({<status={'yes'},YearMonth={'$(=Month(today()))'}>}id)

tresB — Wed, 09 Sep 2020 10:10:11 GMT

Try like:

count({<status={'yes'},YearMonth={`$(=Date(today(),'YYYY-MMM'))`}>}id) // note, inverted quotation

Vegar — Wed, 09 Sep 2020 10:35:11 GMT

As @tresB is showing in his reply - you need to format the output of your today() expression so it matches the format in your [YearMonth] field.

Your present expression where trying to compare YearMonth to a month short name like 'Aug' or 'Sep' depending on the output of today().

sunny_talwar — Wed, 09 Sep 2020 11:30:17 GMT

You can also try

Count({<status = {'yes'}, YearMonth = {"$(=Date(Today(), 'YYYY-MMM'))"}>} id)

Count({<status = {'yes'}, YearMonth = {[$(=Date(Today(), 'YYYY-MMM'))]}>} id)