Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

cancel
Showing results for 
Search instead for 
Did you mean: 
Carlaf_93
Creator
Creator

Extract data from a pivot table

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.

Carlaf_93_0-1598263631997.png

repeated like the hospital column.....

 

1 Solution

Accepted Solutions
MohasinKhan
Contributor III
Contributor III

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.

View solution in original post

1 Reply
MohasinKhan
Contributor III
Contributor III

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.