Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
arulsettu
Master III
Master III

Sort column values in pivot table

hi

in my pivot table month field showing as follow

1

2

3

4

5

6

7

but i need to show horizontally

1 2 3 4 5 6 7

how can i do this any suggestions?

thanks

1 Solution

Accepted Solutions
ashfaq_haseeb
Champion III
Champion III

Drag dimension to upwards or post sample

Regards

ASHFAQ

View solution in original post

9 Replies
ashfaq_haseeb
Champion III
Champion III

Hi,

Right Click Listbox properties --> go to presentation tab --> and deselect single column

Now drag your list box horizontally and then vertically.

Hope it helps

Regards

ASHFAQ

arulsettu
Master III
Master III
Author

no it was in pivot table

ashfaq_haseeb
Champion III
Champion III

Drag dimension to upwards or post sample

Regards

ASHFAQ

arulsettu
Master III
Master III
Author

my pivot table like this

Capture.JPG.jpg

but i need like this

Capture1.JPG.jpg

mjayachandran
Creator II
Creator II

Try to merge Year and Month into a single column like 'Jan 2013' , 'Feb 2013'....

or '2013-01', '2013-02' and so on then Drag the dimension to upwards.

Not applicable

Hi,

Just you drag the vertical line (column) and drop the same on the horizontal line (row)

Priyantha.

arulsettu
Master III
Master III
Author

here the app

anbu1984
Master III
Master III

Check "Qlikview Create a Pivot Table by RFB 161 - YouTube". Remove spaces in link

www.youtube.com/watch ? v=txgHKIoPQRM

mjayachandran
Creator II
Creator II

check if this works for you