How to add a calculated row for a Chart Pivot / St... - Qlik Community

Report Inappropriate Content · ‎2012-07-27

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??

jonathandienst · ‎2012-07-27

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

Report Inappropriate Content · ‎2012-07-27

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'

Report Inappropriate Content · ‎2012-12-12

Hi

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

Report Inappropriate Content · ‎2012-12-13

Hi,

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

Report Inappropriate Content · ‎2012-12-17

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.

giakoum · ‎2012-12-17

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

data:

LOAD PL,

Department,

Amount

FROM

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

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

AdditionalData:

LOAD

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