Show value as % of row total

[Fabien]

Hi all,

I would like to create an expression in Qliksense that shows value as % of row total TEU, based on the Quote Type.

Is there a way to do that in Qliksense?

[mato32188]

Hi Fabien,

try to use sum(TUE)/sum( total <Quote Type> TUE).

BR

Martin

[Fabien]

Hi Martin,

Thanks for your response.

I have amended your expression slightly, as i have multiple Quote Types, however it still doesn't display the correct %. The idea is to have the weekly % between Quote type totaling up to 100%.

sum(TEU)/sum( TOTAL <[Quote Type]> TEU)

Appreciate any assistance.

Fabien

[Fabien · Accepted solution]

I've identified a solution to this.

Here it is, just in case it helps anyone else:

Sum(TEU)/Sum(total <"Week Num"> TEU)