# QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Register for Events and Webinars directly from Qlik Community: http://bit.ly/2Vpnenx
Highlighted
Not applicable

## How to add a calculated row for a Chart Pivot / Straight table?

I have a chart table with 1 dimension and multiple expressions.

In this dimension there are different lines (rows). Between these rows I want to add a calculated field. In the attached picture you see exactly what I want, but I really don't have a clue how to do this.

Does someone know how to do this??

8 Replies
Highlighted
MVP

## Re: How to add a calculated row for a Chart Pivot / Straight table?

Hi

This could be a little more complex than you thought. I suggest that you post your model (at least with sample data if its too big/confidential) so that someone can show your how.

Please also provide details of the desired calculated expression.

Regards

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Highlighted
Not applicable

## Re: How to add a calculated row for a Chart Pivot / Straight table?

Hi,

Please find an example attached (with fake data). What I want is a row under 'Operating margin' which is a calculated field based on the following formula:

'Operating Margin' divided by 'Total Revenue'

Highlighted
Not applicable

## Re: How to add a calculated row for a Chart Pivot / Straight table?

Hi

Did you find a solution to your question ? I'm also interested by this.

Highlighted
Not applicable

## Re: How to add a calculated row for a Chart Pivot / Straight table?

Hi,

I have not received an answer on this yet. As far as I know this is not possible (unfortunately..).

Highlighted
Not applicable

## Re: How to add a calculated row for a Chart Pivot / Straight table?

Thank you for your answer. Since my last post, I do maybe have found a way to achieve that by creating a island table to create rows label, and after you create a conditional formula based on labels.

Hope this help.

Highlighted
Partner

## Re: How to add a calculated row for a Chart Pivot / Straight table?

it would be easier to add it in the actual reload :

data:

Department,

Amount

FROM

C:\Users\motter\Desktop\Example.xls

(biff, embedded labels, table is Sheet1\$);

'Operating Margin divided by Total Revenue' as PL,

min(Department) as Department,

sum(Amount) as Amount

Resident data

Where

(PL = 'Operating Margin' or PL = 'Total Revenue')

and Department = '1';

'Operating Margin divided by Total Revenue' as PL,

min(Department) as Department,

sum(Amount) as Amount

Resident data

Where

(PL = 'Operating Margin' or PL = 'Total Revenue')

and Department = '2';

Highlighted
Not applicable

## Re: How to add a calculated row for a Chart Pivot / Straight table?

Hi,

Can you post an example with respect to island table and how we can create calculated  rows in it!!!!