topic Re: Text Concatenation in QlikView

Text Concatenation

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have create a pivot table and I have checked the partial sums box in presentation tab.

I don't want to see the word total so I had changed the label for totals to ='Total' &[Inventory Item Code]

However, the pivot table only returns the word Total as shown below

swuehl — Wed, 21 Dec 2016 16:13:59 GMT

I believe the text that should be shown in a total line can only be set in total context, i.e. you can't change it per dimensional value.

Wed, 21 Dec 2016 16:28:33 GMT

Hi Stefan

Thanks for getting back to me so you can set it to any text you like but can't put the dimension in?

swuehl — Wed, 21 Dec 2016 16:34:55 GMT

You can put anything in you can also print in a text box chart object, I believe. Hence no value specific to the line.

Wed, 21 Dec 2016 17:07:56 GMT

Ok thanks. I thought you'd be able to pull values through