topic Re: Sort column values in pivot table in QlikView

Sort column values in pivot table

arulsettu — Tue, 07 Oct 2014 07:47:13 GMT

in my pivot table month field showing as follow

but i need to show horizontally

1 2 3 4 5 6 7

how can i do this any suggestions?

thanks

ashfaq_haseeb — Tue, 07 Oct 2014 07:50:56 GMT

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 — Tue, 07 Oct 2014 07:52:02 GMT

no it was in pivot table

ashfaq_haseeb — Tue, 07 Oct 2014 07:59:27 GMT

Drag dimension to upwards or post sample

Regards

ASHFAQ

arulsettu — Tue, 07 Oct 2014 08:04:06 GMT

my pivot table like this

but i need like this

mjayachandran — Tue, 07 Oct 2014 08:09:37 GMT

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.

Tue, 07 Oct 2014 08:11:01 GMT

Hi,

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

Priyantha.

arulsettu — Tue, 07 Oct 2014 08:29:00 GMT

here the app

anbu1984 — Tue, 07 Oct 2014 08:45:58 GMT

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

www.youtube.com/watch ? v=txgHKIoPQRM

mjayachandran — Tue, 07 Oct 2014 09:31:01 GMT

check if this works for you