Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
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

View solution in original post

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