This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
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?
repeated like the hospital column.....
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