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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
salezian
Creator
Creator

Question about sum(total<>)

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

12 Replies
sunny_talwar

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
Creator
Creator
Author

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))