Can ='SUM' & (TEXT) be done, and what about hiding Pivot-columns? (having Nightmares now..) :-)

[anitamelbye]

Dear smart QlikView-people out there - I hope someone can answer my questions?

I highly appreciate any feedback that I get - even if the problems I would like to have solved, can't be solved, I would at least like to know. I'm dreaming (nightmares) about this at night now 🙂

Q1:
Is it possible in a pivot to add personalized text in the dark green SUM-lines?
(See my attached report)

For each sum by column A, I have a text to match. If I write =SUM(TEXT) Qlikview does not know what I want. If I write =MAXSTRING(TEXT) QlikView returnes the same text on all the sumlines (off course).

I would like to have the text for A1 to show in A1's total, and the text for A2 to show in A2's total

Can this be done? Any ideas anyone?

Q2:
Is it possible to hide columns in a pivot-table? I really would like to hide the three first columns, but I have not found a way to do so. I don't think it can be done in a Pivot, am I right?

*Newbee in Looove*

[boorgura]

Not sure, if you were already aware of. Columns can be hidden in a Straight table and not in a pivot table.

and i did not get what your other question was!!! is it concatenating or adding??

[anitamelbye]

Thank you for replying.

Q2: Just like I thought, columns in a Pivot can not be hidden, thank you for confirming my thoughts.

Regarding Q1: What I want to have done is:
- The first sum: 58.719.948 is SUM INCOME
- -18.084.228 is SUM COSTS
etc etc...

I have NO idea how to do this, and I have tried everything. I have a table where the number from the first column is connected to the text, but that is as far as I get...

Any ideas anyone?

*newbee*

[johnw]

You can change the text on the Presentation tab. Under Dimensions and Expressions, select the field for the text you want to change, and enter your text in the "Label for Totals" box.

I'm not sure exactly what you're trying to accomplish by hiding the columns. You can REMOVE columns, obviously. My guess is that you'd want to remove some columns, then use aggr() in your expression(s) to calculate totals as if the columns were still there. But without more specifics on what you're trying to do, I can't really give you an exact solution.

[anitamelbye · Accepted solution]

This thread solved my problem: http://community.qlik.com/forums/t/25508.aspx

Thank you all for trying to help me!

*Newbee even more in love*

[anitamelbye]

This thread solved my problem: http://community.qlik.com/forums/t/25508.aspx

Thank you all for trying to help me!

*Newbee even more in love*