Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

cbaqirdhds
Contributor II

Display Future Months

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!

Tags (3)
5 Replies
ecolomer
Honored Contributor II

Re: Display Future Months

Try this:

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

for the future Months than selected Month

cbaqirdhds
Contributor II

Re: Display Future Months

Where am I trying that expression, Enrique?

ecolomer
Honored Contributor II

Re: Display Future Months

In a pivot table for example

P08.png

ecolomer
Honored Contributor II

Re: Display Future Months

Can you see good?

cbaqirdhds
Contributor II

Re: Display Future Months

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)
)

Community Browser