Skip to main content

QlikView Administration

Discussion Board for collaboration on QlikView Management.

Skip the ticket, Chat with Qlik Support instead for instant assistance.
Showing results for 
Search instead for 
Did you mean: 
Partner - Creator III
Partner - Creator III

Pivot table format change after publishing

Hi all,

I have published my application and have just came across this problem with pivot table formatting after publishing it.

I have set a pivot table formatting and expected the formatting to be the same after publishing…but unfortunately no.

What did happen is:

Original format of the pivot table:

Dimension nameExpression 1Expression 2

Format of the pivot table after publishing:

Dimension nameHeader 3
NameExpression 124
NameExpression 230
TotalsExpression 124
TotalsExpression 230

I would not have a problem with it as I know I can just simply move the columns around and achieve the Original format of the table, although I do not want my users to have to do that too…So I would appreciate any advice on how to achieve that the Original format of the pivot table will be the same after publishing the application.

Hope this makes sense. Please let me know if you need any further clarification.


2 Replies
Partner - Creator
Partner - Creator


This probably sound crazy but what happen if you disable allow pivoting under chart properties> presentations?


Partner - Creator III
Partner - Creator III


have not tried that one, but instead I have deleted all QV temporary files and rerun the job in QVMC. This fixed the problem….