Calculate Procent

[#1]

Hi,

I have a report with a few column:

Total 254

Promotor 30

Passive 163

Detractor 61

I would like to have a extra row that convert the data in  % .

Promotor 11%

Passive 65%

Detractor 24%

Total 100%

Can you explain how I have to do this, I'm new in Qlikview.

Thanks

Yves

[alexandros17]

The idea is

Sum({$ <myField={'Promotor}>} myValue) / Sum(myValue)

But it depends on you data structure

[maxgro]

perhaps

sum (field) / sum (total field)

another one check relative

remember to format as % in Number tab

[fernando_tonial]

You create a chart, select a dimension and create a expression

For expression try this.

Num(Sum(FieldValue) / Sum(Total FiledValue),'0%')

Best Regards.

Tonial.

[MK_QSL]

Can you please share your sample file ?

In straight table, simply create another same expression and for 2nd expression tick Relative...

For Pivot Table like below

SUM(Sales)/SUM(Total Sales)

[#6]

Check this file

[#7]

Ravi,

Your file help me to solve my problem.

Thanks a lot

Greats Yves