How can we export current selections along with a table when we export to excel in qliksense

[naveen341]

Hi  stalwar1‌

bps‌ziadmohd1‌vvvvvvizard‌gwassenaar‌ogster1974‌robynrshields‌

I am trying to export a table to excel can we export the table along with the current selections in qliksense.

can you please help me to figure this out.

Regards,

naveen.

[Thiago_Justen_]

Don't mention it. It'll be a pleasure help you.

Searching...

[OmarBenSalem]

do sthing as follow:

create a new column in ur table as follow:

=aggr(if(len(Above(OneOfYourDimensionsInTheTable))>0,'', GetCurrentSelections(' | ')),OneOfYourDimensionsInTheTable)

in my case :

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

Result:

and now, when u export ur table, u'll find ur current selections

[ogster1974]

I understand your request.   You want to export the data along with the filters you have selected to provide context to your exported data without interaction.

You cannot do this with standard export.   if you want that context in exports of explore data stories or no ringing

[shlomoh]

You can do this and much more, using LogiExport extension for QlikSense
https://logiexport.logsys.co.il/documentation