Extract data from a pivot table

[Carlaf_93]

Good morning,

i have a pivot table and i would like to extract the data in the format that you see when you select 'visualize data'.

So all the field are repeated as in a normal table. When you extract it in excel you have a single field in a union... and not separeted 

How can i have an extracrion with repetition?

Thanks.

repeated like the hospital column.....

[MohasinKhan · Accepted solution]

Hi, 

In Qliksense unfortunately, there is no option to fill the fields. Reason is, Qliksense pivot table merges the cells.

I generally download the table and create my own pivots in excel.

However, I have a work around which may help.

Once you download the pivot into excel, select the entire column in excel and click Merge & Center under Home Menu (Alignment) of excel. (See attached screenshot)

Hope it helps.