Question about sum(total<>)

[salezian]

Dear Qlik fans,

Is there any way to include in total keyword all columns in the chart except two specific. The idea is to include always in the expression all columns in the chart except two specific fields like sum(total<all columns - {column1, column2}>) ? Of course I could write all columns manually but this is ad hoc chart and it would be difficult to manage it.

I'd be grateful for any ideas

BR

[sunny_talwar · Accepted solution]

Because you need $() expansion to let QlikView know that the list that is displayed is actual field names and not just any random list of names....Might be able to read some of it here

The Magic of Dollar Expansions

[salezian]

I've used by creating variable with following expression

vTotal: =Concat(DISTINCT {<_AdHocTableCode -= {'Field1', 'Field2'}>} AdHocTableCode )

Then I've used in chart as $(vTotal). And my understanding that this expression will return column names.

That's why I'm confused.

[sunny_talwar]

Try one of these

$(=vTotal)

or

$(=$(vTotal))