topic Re: Display Future Months in QlikView

Display Future Months

cbaqir — Tue, 23 Sep 2014 18:49:54 GMT

I am building a dashboard that shows a straight table of roles with a negative FTE Variance. I have two dimensions: MonthYear and Role. FTE Variance is an expression that looks at the total of hours of resource capacity/possible working hours minue the total of hours allocated/possible working hours.

It only shows records where the FTE Variance is less than 1 by using the Dimension Limits->Show only values that are Less Than -1 exact amount.

I want this table to only show the records in the future months (to allow the user to identify resource gaps). I was trying to get it to show by using Dimension Limits->Show only values that are Greater than today() on the MonthYear field, but it isn't working.

Help!

Re: Display Future Months

ecolomer — Tue, 23 Sep 2014 19:03:22 GMT

Try this:

Sum({<MonthYear ={">=$(=Max(MonthYear))"}>} Role)

for the future Months than selected Month

Re: Display Future Months

cbaqir — Tue, 23 Sep 2014 19:05:36 GMT

Where am I trying that expression, Enrique?

Re: Display Future Months

ecolomer — Tue, 23 Sep 2014 19:13:55 GMT

In a pivot table for example

Re: Display Future Months

ecolomer — Tue, 23 Sep 2014 19:14:13 GMT

Can you see good?

Re: Display Future Months

cbaqir — Tue, 23 Sep 2014 19:18:02 GMT

So, I have my expression that calculates the negative FTE in the Expression Definition ( $(vHeadcount) ).

I'm confused on where your expression would go...

SUM
(
{$<EFFORT_DATE = {">=$(#vCurrentDate)"}>}
$(vHeadcount)
)