Skip to main content

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 
Search instead 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
jonathandienst
Partner - Champion III
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.

giakoum
Partner - Master II
Partner - Master II

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

Not applicable
Author

Hi,

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

Thanks in advance!!!!

Not applicable
Author

Hi,

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

Thanks in advance!!!!