topic Re: Percent Calculation in Straight tbl in QlikView

Percent Calculation in Straight tbl

surajap123 — Thu, 01 May 2014 14:32:44 GMT

Hi All

I am here addressing the Expression and Number tabs in Straight table to show value in percentage.

I want to know the difference between Relative checkbox in Expression tab and in Number tab the 'fixed to' with enabling 'show in percent'.

I am using below expression in straight table to calculate the Year to Date Variance-

(Column(1) - Column(2)) / Column(1)

When I select relative checkbox in expression tab, i get 100% as value in my straight table column.

when i select 'fixed to' 2 Decimals and enable show in percent, i get the right percentage value.

Please let me know the usage of Relative checkbox and 'fixed to with show in percentage'.

MK_QSL — Thu, 01 May 2014 14:40:03 GMT

Consider below script...

Load * Inline

[

Customer, Sales

A, 100

B, 120

C, 300

D, 500

E, 50

];

Create a straight table

Dimension = Customer

Expression

1) SUM(Sales)

2) SUM(Sales)/SUM(Total Sales) Number Tab Fixed to 2 Decimals and Show in %

3) SUM(Sales) Relative Ticked

Here 2nd and 3rd will give you same result.

maxgro — Thu, 01 May 2014 14:51:38 GMT

first expression sum(sales)

second expression sum(sales) relative checked

third expression sum(sales) relative checked formatted in number tab show in %

use number tab for formatting

use relative if you want Qlikview calculates the %

in your case you calculates the %, so don't check relative, just format