Announcements
[WEBINAR] Accenture & Qlik: Accelerating BI Migration to SaaS with Qlik on Dec 13th: REGISTER
cancel
Showing results for
Did you mean:
Partner - Creator

## Set expression

Hi,

I need an expression to blank the forecast for any month where the date is < today. I only require the forecast for the future months.

In the attached example the forecast bar for July 2017 should be blank.

I tried the expression but it is incorrect:-

Sum ({\$<Month={'>=\$(=date(today()))'}>}Forecast)

Any ideas?

Thanks

1 Solution

Accepted Solutions

May be this for forecast

If(Date(MonthName(Today()),'MMM-YY')=Month,' ',Sum (Forecast))

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
9 Replies

May be this for forecast

If(Date(MonthName(Today()),'MMM-YY')=Month,' ',Sum (Forecast))

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
MVP

Please find the attachment for the solution

Master

hi

how below expression is excluding past values

If(Date(MonthName(Today()),'MMM-YY')=Month

Haha, May be use sign operations like > and < and >= and <=

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

try this expression, you need to provide the correct format of month in your set analysis

Sum ({\$<Month={">=\$(=date(today(),'MMM YYYY'))"}>}Forecast)

Master

haha..ok ..fine then

Creator II

Try the below expression

Sum ({\$<Month={">\$(=date(today(),'MMM-YY'))"}>}Forecast)

Specialist

Hi,

Try the below expression-

Sum ({\$<Month={">=\$(=date(today(),'MMM-YY'))"}>}Forecast)

Thanks,

neha

Specialist

Only > not >=

corrected -

Sum ({\$<Month={">\$(=date(today(),'MMM-YY'))"}>}Forecast)

Community Browser