topic Inter-Record-Function in QlikView

Inter-Record-Function

Fri, 28 Jun 2013 11:12:54 GMT

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

Re: Inter-Record-Function

Gysbert_Wassenaar — Fri, 28 Jun 2013 11:23:35 GMT

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

Re: Inter-Record-Function

swuehl — Fri, 28 Jun 2013 11:24:33 GMT

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.