expression modification

decopipo — Tue, 08 Sep 2020 09:45:06 GMT

Hello,

I have a scenario , need to prepare a standard expression for

1.Monthly

2. YTD

3.Last twelve months

sum({<$(vCYPeriod),Scenario={'CPL_ACT'}>}Value) [STANDARD FORMULA]

vCYPeriod=Pick(match($(vPeriodType),1,0,2),vPeriodTypeCYMTH,vPeriodTypeCYYTD,vPeriodTypeLast12Months)

vPeriodTypeCYMTH=[Fiscal year]={'$(=$(vCurrYear))'},[Posting period]={'$(=$(vCurrMonth))'}

vPeriodTypeCYYTD=[Fiscal year]={'$(=$(vCurrYear))'},[Posting period]={"<=$(=$(vCurrMonth))"}

vCYPeriod changes as per I select the variable as Monthly,YTD and Last twelve months. For Last twelve months the formula is

<[Fiscal year]={'$(=$(vLast12MonthsStartYear))'},[Posting period]={">=$(=$(vLast12MonthsStartMonth))"}> + <[Fiscal year]={'$(=$(vCurrYear))'},[Posting period]={"<=$(=$(vCurrMonth))"}>

vLast12MonthsStartMonth	if($(vCurrMonth)=12,1,$(vCurrMonth)+1)
vLast12MonthsStartYear	if($(vCurrMonth)=12,$(vCurrYear), $(vPrevYear))

Re: expression modification

Sue_Macaluso — Mon, 16 Mar 2020 14:16:26 GMT

@decopipo Are you using QlikView or Qlik Sense? I would like to move this into the correct product forum.

topic expression modification in Water Cooler

expression modification

Re: expression modification