topic Re: MTD in textbox in QlikView

MTD in textbox

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

Would any one suggest me how to show MTD values in textbox.

Ex. If I select 03rd Dec then textbox should show Total of Dec in textbox.

I tried with Set analysis but I guess I put something wrong.

Please suggest.

Thanks in advance

vinieme12 — Thu, 26 Jan 2017 08:12:04 GMT

Please post the expression you used and the date flags you have in your master calendar

surendraj — Thu, 26 Jan 2017 08:14:09 GMT

Did you try this...

sum({<Year={$(=Max(Year))},Date={'>=$(=monthstart(max(Date)))<=$(=max(Date))'}>}[Sales Amount])

Thu, 26 Jan 2017 08:38:29 GMT

Hi Sir,

Not working sir,

I have Year = Years, Month=Months, Day=[Report Day].

If I select any [Report Day] it should show total of Request of same month.

Ex. If I select 10th Dec it should show total request from 01st Dec to 31st Dec.

Please help

surendraj — Thu, 26 Jan 2017 09:14:02 GMT

May be this..but I am not sure..

Sum({<Years=, Months=,DateField=, [Report Day]={">=$(=Num(MonthStart(Max([Report Day]))))<=$(=MonthEnd(Max([Report Day])))"}>} Sales)

Here you can apply your measure on set analysis.here I used sales as my expression.

Take the dimensions as you have..

vinieme12 — Thu, 26 Jan 2017 09:16:48 GMT

if you have a Report Month! field

sum({<ReportYear={$(=Month([Report Day]))},[Report Month]={"$(=Month([Report Day]))"}>}[Sales Amount])