topic Re: MTD / YTD Is there a better way? in QlikView

MTD / YTD Is there a better way?

farnsworth — Mon, 26 Jan 2026 18:19:17 GMT

Hi All,

In my data table i'm trying to display MTD and YTD using a calculation which I have stored in a variable "vQuotes" (below).

SUM({<[Plan Type]={'Actual'}>} Quote_Count)

The fact calendar I have created has flags for MTD and YTD. What I was hoping to do in the front end data table which in theory should be simple but I can't get this to work is the following :

$(vQuotes) * MTD

and another for YTD

$(vQuotes) * YTD

I can get around this by creating new variable which I would call "vQuotesMTD" and would be as follows:

SUM({<[Plan Type]={'Actual'}, MTD = {1}>} Quote_Count)

But it would mean multiple variables which are only used once and are basically the same.

Is it possible to do this it this way?

$(vQuotes) * MTD

Re: MTD / YTD Is there a better way?

Kushal_Chawda — Fri, 06 May 2016 16:04:41 GMT

No this will not work. You are multiplying your expression with MTD Flag i.e 1 means you are actually getting the values for that expression not the MTD values. So you need to use MTD Flag in set analysis SUM({<[Plan Type]={'Actual'}, MTD = {1}>} Quote_Count)

Re: MTD / YTD Is there a better way?

Tanalex — Fri, 06 May 2016 16:25:55 GMT

This may be of value. It helped me tremendously.

https://qlikcentral.com/2015/11/10/date-comparison-with-a-powerful-calendar/

Re: MTD / YTD Is there a better way?

farnsworth — Mon, 09 May 2016 13:22:54 GMT

Hi Kushal & Michael, thanks for you responses.I feared this was the case and thanks for the calendar link this is really useful.