Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
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

Drag dimension to upwards or post sample

Regards

ASHFAQ

View solution in original post

9 Replies
ashfaq_haseeb

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

no it was in pivot table

ashfaq_haseeb

Drag dimension to upwards or post sample

Regards

ASHFAQ

View solution in original post

arulsettu
Master III
Master III

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

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