Exp changes

yogitamehta10 — Thu, 20 Aug 2015 09:42:17 GMT

Hi,

I have this Expression at the front end . i'm trying to do all this calculation at the backend, any idea how should i proceef

if(count(distinct if([ Measure Code] = 'EI' and [Measure Date] >= Today()-$(LookbackDays) and [Measure User ] = '$(User)',[Measure Site Co]))= 0,0,

if(sum(if( Measure Code] = 'EI' and [Measure Date] >= Today()-$(LookbackDays) and [ Measure User ] = '$(User)' and Upper(Text([Measure Control]))<> 'N',[ Measure Population]))<>0,

1-(sum(if([Measure Code] = 'EI' and [Measure Date] >= Today()-$(LookbackDays) and [Measure User ] = '$(User)' and Upper(Text([Measure Control]))<> 'N',[Measure Exceptions]))

/sum(if([HM Measure Code] = 'EIM08' and [Measure Date] >= Today()-$(LookbackDays) and [Measure User] = '$(User)' and Upper(Text([Measure Control]))<> 'N',[Measure Population]))),0))

*$(EIM08DW)

if(count(distinct if([Measure Code] = 'ESM04' and [Measure Date] >= Today()-$(LookbackDays) and [Measure User ] = '$(User)',[Measure Site ]))= 0,0,

if(sum(if([Measure Code] = 'ESM04' and [Measure Date] >= Today()-$(LookbackDays) and [Measure User ] = '$(User)' and Upper(Text([Measure Control]))<> 'N',[Measure Population]))<>0,

1-(sum(if([Measure Code] = 'ESM04' and [Measure Date] >= Today()-$(LookbackDays) and [Measure User Type] = '$(User)' and Upper(Text([Measure Control]))<> 'N',[Measure Exceptions]))

/sum(if([Measure Code] = 'ESM04' and [Measure Date] >= Today()-$(LookbackDays) and [Measure User Type] = '$(User)' and Upper(Text([Measure Control]))<> 'N',[Measure Population]))),0))

*$(ESM04DW)

Re: Exp changes

gautik92 — Thu, 20 Aug 2015 10:02:25 GMT

Epression changes

topic Exp changes in QlikView

Exp changes

Re: Exp changes