Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Inter-Record-Function

Hi,

I've got a problem with interrecord-functions. In a Pivot-Table I'd lile to make a refernce from a summary-row to the text of the column left - see snapshot:

So that in the end the text now filled with 'Gesamt' is concatenated with the text of the column 'Auftragsgruppe', e.g.: '9491 Gesamt'. I made several approaches with above, befor, fieldvalue .... but none of them works. Has anybody an idea?

Kind regards,

Matthias

2 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

See this post. As far as I know that's the only way to create custom totals labels.


talk is cheap, supply exceeds demand
swuehl
MVP
MVP

I can't see your screen shot, so it's like a walk in the dark.

I believe you can't reference the other column from your total column using inter record functions. But if you are using a partial sum and the Auftragsgruppe is unambiguous in that context, just call the field value:

=only(Auftragsgruppe) & ' Gesamt'

edit:

Now I can see the screenshot. The solution I suggested won't work.