Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Problem in Expression ..

Hi Frnz,

I was stuck at small expression. I need to show sum(L2AMID_VALUE_USD) in the basis of L2AMID field. I have used in AGGR in expression. But it is not working.

Please help to find solution. Please find the attached QVW.

L2AMID ===> Account ids

L2AMID_VALUE_USD ====> Measure in USD$


1 Solution

Accepted Solutions

Re: Problem in Expression ..

Hi,

Try Sum(Aggr(sum(L2AMID_VALUE_USD),L2AMID))

regards

Regards,
Prashant Sangle
5 Replies

Re: Problem in Expression ..

Hi,

Try Sum(Aggr(sum(L2AMID_VALUE_USD),L2AMID))

regards

Regards,
Prashant Sangle
prajapatiamar38
Contributor II

Re: Problem in Expression ..

Hii

PFA

Is that you want

Thanks

Not applicable

Re: Problem in Expression ..

Hi Max,

Thanks for your reply. It is showing wrong totals. It is not working properly

Not applicable

Re: Problem in Expression ..

Hi - I could see two dimesions are already in use. While solution given by max dreamer should work, could you please let us know what is the expected result?

Not applicable

Re: Problem in Expression ..

sorry..It is working..Thanks Max

Community Browser