Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

onkarkulkarni
New Contributor II

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

4 Replies
OmarBenSalem
Esteemed Contributor

Re: Total disappears in export to excel in Qliksense

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
Contributor

Re: Total disappears in export to excel in Qliksense

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
Esteemed Contributor

Re: Total disappears in export to excel in Qliksense

Nope.

pauljohansson
Contributor III

Re: Total disappears in export to excel in Qliksense

Community Browser