Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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.
Try one of these
$(=vTotal)
or
$(=$(vTotal))