Qlik Community

Qlik Sense App Development

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

paulyeo11
Valued Contributor II

Why Amount)/Rate not allow when compute GP% ?

Hi All

Below expression from table 2 okay :-

Sum({<rEVENUE={rEVENUE}>}Amount)/Rate

Below expression from Table 3 not okay :-

(

sum({$<YTD = {'-1'} , rEVENUE={rEVENUE}>}Amount)/Rate

-

sum({$<LY_YTD = {'-1'} , rEVENUE={rEVENUE}>}Amount)/Rate

)

/sum({$<LY_YTD = {'-1'} , rEVENUE={rEVENUE}>}Amount)/Rate

May i ask why first expression allow to place /Rate after Amount) , and second expression not allow ?

Paul

3 Replies
paulyeo11
Valued Contributor II

Re: Why Amount)/Rate not allow when compute GP% ?

my QVW

MVP
MVP

Re: Why Amount)/Rate not allow when compute GP% ?

What is the rate that you expect to see?

paulyeo11
Valued Contributor II

Re: Why Amount)/Rate not allow when compute GP% ?

Hi Sunny

Now table 3 display -7% is wrong , it should display -47% as shown in Table 4.

I cannot understand why if i put Rate out side Amount)/Rate at Sum expression it is okay , but not okay when compute GP% ?

Paul

Community Browser