Construct Expression

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

Hi,

Please let me know how to add the below logic into the expression:

Logic:Sum(INVCOUNT)/sum(ESTCUST)

Expression:

if(GetcurrentField(Calendar)='SoldYear',if(SoldYear=$(vMaxYear),(sum(ESTCUST)-above(total sum({<SoldMonth={'<=$(=max({<SoldYear={"$(=max(SoldYear))"}>}SoldMonth))'}>}ESTCUST)))

above(total sum({<SoldMonth={'<=$(=max({<SoldYear={"$(=max(SoldYear))"}>}SoldMonth))'}>}ESTCUST)),(sum(ESTCUST)-above(total sum(ESTCUST)))/above(total sum(ESTCUST))),

if(GetCurrentField(Calendar)='SoldMonth',(sum(ESTCUST)-sum({<SoldYear={"$(=max(SoldYear)-1)"}>} ESTCUST))/sum({<SoldYear={"$(=max(SoldYear)-1)"}>} ESTCUST),

if(GetCurrentField(Calendar)='SoldDay',(sum(ESTCUST)-sum({<SoldYear={"$(=max(SoldYear)-1)"}>} ESTCUST))/sum({<SoldYear={"$(=max(SoldYear)-1)"}>} ESTCUST))))

In the above expression instead of ESTCUST i need to replace Sum(INVCOUNT)/sum(ESTCUST).

Thanks..

Re: Construct Expression

nareshthavidishetty — Wed, 04 Jan 2017 18:23:52 GMT

Hi,

Please let me know how to get this.

Thanks..

topic Re: Construct Expression in QlikView

Construct Expression

Re: Construct Expression