Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

Issue while doing sum at record level

Hi Team,

I having issue while doing sum at record level. My expression returns sum of whole QUANTITY into average of whole RATE  by sum of whole VALUE

Formula: sum(Qty)*Avg(Rate) / sum(Value)

Expression:

=(Sum({<Year={$(=max(Year))}>} Qty) * avg({<Year={$(=max(Year))} >}Rate))/

(sum({<Year={$(=max(Year))} >} DISTINCT (Value))))

Note: Using current year.

Please check attached sheet for more details and with e.g.

Quick help will be appreciated.

Thanks,

Yudi

4 Replies
sureshqv
Esteemed Contributor III

Re: Issue while doing sum at record level

frm where ur getting year filed?

sureshqv
Esteemed Contributor III

Re: Issue while doing sum at record level

chk dis

MVP
MVP

Re: Issue while doing sum at record level

You explain what you are trying to do, but what is the question/issue?

sureshqv
Esteemed Contributor III

Re: Issue while doing sum at record level

chk dis

its wrkng fyn

barchart.png

Community Browser