Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

Not applicable

How to sort and maintain static cells in a pivot table?

Hello,

I have a problem when sorting a pivot table like this: In this example, I have two dimensions A,B and my main problem is that when I try to select one 'square' for instace, A=feb and B=january,=18,54%.


My pivot table remains like this ; Notice that in the x-axis ,the cell of January has been shifted to the right while the others ( feb and march) have been exchanged.On the other hand, in the y-axis, all the cells except for 'feb' have disappeared.

What I would like to get it's this order, just having all the cells static and ordered by the name of the month.


I appreciate any suggestions.

Many thanks,

B

Community Browser