topic Re: how to create a MTD set analysis in QlikView

how to create a MTD set analysis

jim_chan — Tue, 07 Feb 2017 15:06:12 GMT

Hi guys,

I have a data that have key in with future date and data. and i would like apply MTD for a KPI object. This is my set analysis

Count({<Day=,Year=, Month=, Quarter=, Week=, Date=, DateNum={">=$(=Num(MonthStart(Max({<Day>}DateNum))))<=$(=Max({<Day>}DateNum))"}>} VISIT_KEY)

Now... after applying this, i dont understand why the MTD is 3 DEC 2017, that is the last record.

I would like to set the MTD, to calculate Month to Date, like now, is Feb 2017, suppose the MTD should be from 1 Feb til today 7 Feb.

How can i get that analysis with the above MTD set analysis?

Rgds

Jim

sunny_talwar — Tue, 07 Feb 2017 15:11:28 GMT

May be use Today() instead of Max(DateNum)

Count({<Day=,Year=, Month=, Quarter=, Week=, Date=, DateNum={">=$(=Num(MonthStart(Today())))<=$(=Num(Today()))"}>} VISIT_KEY)

But what is the point of doing till 7th if you only have data until 3rd?

jim_chan — Tue, 07 Feb 2017 15:21:40 GMT

Hi bro, i got 0 Value.. i click anything also 0 .

any missing bracket in ur set analysis???

sunny_talwar — Tue, 07 Feb 2017 15:23:37 GMT

Doesn't seem like I missed any parenthesis.... not sure

jim_chan — Tue, 07 Feb 2017 15:28:35 GMT

the data is until 3rd of DEC 2017... and the MTD is showing me this date's figure.

sunny_talwar — Tue, 07 Feb 2017 15:36:36 GMT

MTD is showing you this date's figure? for Dec 3rd 2017?

jim_chan — Tue, 07 Feb 2017 15:49:33 GMT

yeah. and i max(date) - it shows ing 3rd Dec.

sunny_talwar — Tue, 07 Feb 2017 15:51:38 GMT

But I didnot even suggest you to use Max(Date).... I mentioned to use Today(). You cannot change to Today()?

jim_chan — Tue, 07 Feb 2017 15:53:26 GMT

yes i did follow. but shows me 0 value...nothing...

ount({<Day=,Year=, Month=, Quarter=, Week=, Date=, DateNum={">=$(=Num(MonthStart(Today())))<=$(=Num(Today()))"}>} VISIT_KEY)

sunny_talwar — Tue, 07 Feb 2017 16:02:02 GMT

Can't say... may be someone else might know

bwisealiahmad — Thu, 09 Feb 2017 00:55:50 GMT

Why not create a current month flag instead?

If(Month(Date) = Month(Today()), 1, 0) as [DateCurrentMonthFlag],

And use that in your set analysis?