Qlik Community

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

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

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 = '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!!!!

Thanks in advance!!!!

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

Thanks in advance!!!!