topic Re: expressn in QlikView

expressn

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

i have a tricky situation where i need to sum diffierent values in expression

sum({<Source={'SAP'}, Category = {'Finance'},Object = {'23'},[Code] = {'91'},Entity = {'CRKNM'} >}Amount_Euro)

sum({<Source={'SAP'}, Category = {'Finance'},Object = {'23'},[Code] = {'91'},Entity = {'LMGCR'} >}Amount_Euro)

sum({<Source={'SAP'}, Category = {'Finance'},Object = {'23'},

 = {'91'},Entity = {';KOPDD'}  >}Amount_Euro)

the above is not working...any suggestion

Re: expressn

m_woolf — Mon, 13 Aug 2018 16:08:29 GMT

If you are getting a null result, it could be because one of the three sub expressions is null.

try using Rangesum:

Rangesum(sum({<Source={'SAP'}, Category = {'Finance'},Object = {'23'},[Code] = {'91'},Entity = {'CRKNM'} >}Amount_Euro),sum({<Source={'SAP'}, Category = {'Finance'},Object = {'23'},[Code] = {'91'},Entity = {'LMGCR'} >}Amount_Euro).sum({<Source={'SAP'}, Category = {'Finance'},Object = {'23'},

 = {'91'},Entity = {';KOPDD'}  >}Amount_Euro))

Re: expressn

Anonymous — Mon, 13 Aug 2018 16:15:50 GMT

Hi Raad,

In the 3rd set expression please remove the semicolon before the Entity value. Entity = {';KOPDD'} The expression would be like below,

sum({<Source={'SAP'}, Category = {'Finance'},Object = {'23'},[Code] = {'91'},Entity = {'CRKNM'} >}Amount_Euro)

sum({<Source={'SAP'}, Category = {'Finance'},Object = {'23'},[Code] = {'91'},Entity = {'LMGCR'} >}Amount_Euro)

sum({<Source={'SAP'}, Category = {'Finance'},Object = {'23'},

 = {'91'},Entity = {'KOPDD'}  >}Amount_Euro)

Thanks,

Sarat.K

Re: expressn

vishsaggi — Mon, 13 Aug 2018 16:36:42 GMT

Why don't you use Entity only once like below:

= sum({<Source={'SAP'}, Category = {'Finance'},Object = {'23'},

 = {'91'},Entity = {'CRKNM', 'LMGCR', 'KOPDD'}                 >}Amount_Euro)