How to apply Excel Formula in QV

[muniyandi]

Hi,

I need excel formula  % of Row Total, % of Column Total   details and how to apply in qlikview. any sample report are available it will be useful.

1. % of Row Total

2. % of Column Total

With Regards,

Muni.

[MK_QSL]

Use below as an expression in my file..

RangeSum(Above(TOTAL SUM(Sales),0,RowNo(TOTAL)))/SUM(TOTAL <Year> Sales)

[muniyandi]

Thanks for All

Steve expression is correct.

sum(avalue)/(sum(TOTAL avalue)+sum(TOTAL bvalue))

and

sum(bvalue)/(sum(TOTAL avalue)+sum(TOTAL bvalue))

===============================================

any option to dynamically add to expression?

Ex:

i have condition to enable the expression.that time condition has passed then sum(total bvalue) expression will be adding.

Thanks,

Muni