topic Re: Calculate Procent in QlikView

Calculate Procent

Thu, 17 Apr 2014 12:20:17 GMT

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

Re: Calculate Procent

alexandros17 — Thu, 17 Apr 2014 12:27:49 GMT

The idea is

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

But it depends on you data structure

Re: Calculate Procent

maxgro — Thu, 17 Apr 2014 12:28:16 GMT

perhaps

sum (field) / sum (total field)

another one check relative

remember to format as % in Number tab

Re: Calculate Procent

fernando_tonial — Thu, 17 Apr 2014 12:30:13 GMT

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.

Re: Calculate Procent

MK_QSL — Thu, 17 Apr 2014 12:30:38 GMT

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)

Re: Calculate Procent

Thu, 17 Apr 2014 12:32:54 GMT

Check this file

Re: Calculate Procent

Thu, 17 Apr 2014 12:54:30 GMT

Ravi,

Your file help me to solve my problem.

Thanks a lot

Greats Yves