topic Re: Project Run Rate in QlikView

Project Run Rate

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

Hello All,

I created a bar graph and I have this as a Calculated Dimension =if(Match(MONTH,'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec')>=Num(Month(Today())),MONTH)

This works but I would like it to start after the first Friday of every month.

We use a time tracking system and we are calculating project run rate. since we enter our time at the end of each week the run rate will show zero until time is entered on this Friday at the end of the week. Because of This we would like the bar chart to still show the last Months run rate until time is entered after the first Friday. I assume i would have to tweak the (TODAY())))) to a different thing.

Re: Project Run Rate

swuehl — Mon, 02 Oct 2017 18:53:19 GMT

Maybe replace Month(Today()) with

Month(Weekstart(Today(),0,4))

Re: Project Run Rate

vishsaggi — Mon, 02 Oct 2017 19:08:51 GMT

May be this?

= if(Match(MONTH,'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec')>= Num(Month(IF(WeekDay(Today())='Fri', Today()))),MONTH)

Re: Project Run Rate

manoj217 — Mon, 02 Oct 2017 19:09:11 GMT

as of my knowledge it will shows the data above of current month

for example: today month is oct data will shows remaining months nov, dec in num format like 11,12 month