topic Re: Set expression in QlikView

Set expression

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

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

Anil_Babu_Samineni — Mon, 24 Jul 2017 07:44:23 GMT

May be this for forecast

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

avinashelite — Mon, 24 Jul 2017 07:51:00 GMT

Please find the attachment for the solution

shiveshsingh — Mon, 24 Jul 2017 08:30:28 GMT

how below expression is excluding past values

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

Anil_Babu_Samineni — Mon, 24 Jul 2017 08:31:52 GMT

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

Kushal_Chawda — Mon, 24 Jul 2017 08:33:58 GMT

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

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

shiveshsingh — Mon, 24 Jul 2017 08:41:05 GMT

haha..ok ..fine then

gayatri7 — Mon, 24 Jul 2017 09:37:16 GMT

Try the below expression

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

neha_shirsath — Mon, 24 Jul 2017 11:16:33 GMT

Hi,

Try the below expression-

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

Thanks,

neha

neha_shirsath — Mon, 24 Jul 2017 11:19:07 GMT

Only > not >=

corrected -

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