# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save \$300 before February 6: REGISTER NOW!
cancel
Showing results for
Did you mean:
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
Partner - Champion III

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
Not applicable
Author

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'

Not applicable
Author

Hi

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

Not applicable
Author

Hi,

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

Not applicable
Author

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.

Partner - Master II

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';

Not applicable
Author

Hi,

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