Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor
Contributor

Totals Excluding a Row

Hi 

Would appreciate assistance in the following. I have  Unique ID in first column, and then the vehicles are duplicated. I have a measure to sum these totals, but it is not adding the duplicated vehicles, unless I click the Totals Option, but I need it to auto sum, as I need to work out the average of the Grand Totals.

Vehicle Util01.jpg

The average should be 62% and not 71%, but if you exclude the 14.00, it gives 71%.

Thanks

Labels (2)
1 Reply
Highlighted
Specialist III
Specialist III

if you want to make total with out Total option you need to have two tables in script

do union(concatenate)

one table you have aggregate data means only totla

Channa