Total disappears in export to excel in Qliksense

[onkarkulkarni]

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

[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:

[gorterzelf7]

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.

[pauljohansson]

https://community.qlik.com/ideas/4788#comment-69903

[gorterzelf7]

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