Solved: Re: Problem in Expression .. - Qlik Community

Report Inappropriate Content · ‎2015-07-24

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$

PrashantSangle · ‎2015-07-24

Hi,

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

regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

View solution in original post

PrashantSangle · ‎2015-07-24

Hi,

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

regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

prajapatiamar38 · ‎2015-07-24

Hii

PFA

Is that you want

Thanks

Report Inappropriate Content · ‎2015-07-24

Hi Max,

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

Report Inappropriate Content · ‎2015-07-24

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?

Report Inappropriate Content · ‎2015-07-24

sorry..It is working..Thanks Max