topic Re: Need help to write expression in QlikView

Need help to write expression

suvechha_b — Tue, 25 Mar 2014 07:13:45 GMT

How to write the following in expressioon :

sum({<[fis_period] = {[Forecast Fiscal Period-1]} >}[Stag Forecast Units])

MK_QSL — Tue, 25 Mar 2014 07:16:35 GMT

sum({<[fis_period] = {'$(=[Forecast Fiscal Period]-1)'} >}[Stag Forecast Units])

PrashantSangle — Tue, 25 Mar 2014 07:17:33 GMT

You can do this way,

sum({<[fis_period] = {=Max([Forecast Fiscal Period)-1]} >}[Stag Forecast Units])

Regards

jagan — Tue, 25 Mar 2014 07:19:14 GMT

Hi,

Try like this, if not works come up with an example

=sum({<[fis_period] = {$(=Max([Forecast Fiscal Period]) - 1)} >}[Stag Forecast Units])

Regards,

Jagan.

suvechha_b — Tue, 25 Mar 2014 08:02:35 GMT

Please check the ex field. I want to calculate that field for all the BucketDescrition :

suvechha_b — Tue, 25 Mar 2014 08:04:04 GMT

see the vw_fact_dop_forecast_stagger in the diagram :