Qlik Community

QlikView Publisher

Discussion Board for collaboration on QlikView Publisher.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

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
                       Name3024
Total3024

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.

T.

2 Replies
Highlighted
Partner
Partner

Re: Pivot table format change after publishing

HI,

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

BR//Gonza

Highlighted
Partner
Partner

Re: Pivot table format change after publishing

Hi,

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

T.