Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
onkarkulkarni
Creator
Creator

Total disappears in export to excel in Qliksense

Hello All,

I have a table in Qliksense dashbaord with customer counts on different levels. I am showing total(customer_ID) in first row. When I right click on Export data, in excel total row is not available.

Is this bug/ limitation in Qliksense ?

Regards,

Onkar Kulkarni

5 Replies
OmarBenSalem

do sthing as follow:

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:

Capture.PNG

gorterzelf7
Partner - Creator
Partner - Creator

Your formula with the totals works good, but is there a way that you see that total in the same column as the totals per dimension, same way as Sense is showing it, but then taking the totals to Excel when export.

OmarBenSalem

Nope.

gorterzelf7
Partner - Creator
Partner - Creator

everyone should make a case with your company then they fix it faster. https://support.qlik.com/