Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.....
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.
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.