Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
rammuthiah
Creator III
Creator III

Total - Export data

Can we bring total while exporting data from a table in Qlik Sense. Since we didn't get total value in excel sheet.

Export Data.JPG

3 Replies
siddharth_s3
Partner - Creator II
Partner - Creator II

No.

Total is a function and no functions can be exported to Excel from Qlik.

OmarBenSalem

do sthing as follow:

create a new column in ur table as follow:

=aggr(if(len(Above(OneOfYourDimensionsInTheTable))>0,'', Sum(TOTAL YourMeasure)),OneOfYourDimensionsInTheTable)

in my case : if I wanted to export the current selections for example instead of the total : (per analogy, it will export the total the same way)

=aggr(if(len(Above([Territory name]))>0,'', GetCurrentSelections(' | ')),[Territory name])

Result:

1.PNG

pablolabbe
Luminary Alumni
Luminary Alumni

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others