topic Sort order in QlikView

Sort order

Fri, 05 Aug 2011 06:35:20 GMT

Hi,

Need to show the latest Six months in ascending order in the chart...

Say for example,

For the Year 2010, chart should display the values from 201007 to 201012 in ascending order...

If particular month has no sales then we need to consider the previous months also like month 201008 has no sales then we need to show the months - 201006 ,201007,201009,201010,201011,201012.

Re: Sort order

SunilChauhan — Fri, 05 Aug 2011 07:42:18 GMT

please see the attached

Re: Sort order

Fri, 05 Aug 2011 17:59:14 GMT

But I guess Shans_Bola wants it for latest 6 months.

So Sunil could you suggest how we can do it.

Because if I change the inline load in your example to something like this,

Tab1:

Load * inline [

colm,sales

201104,20

201105,50

201106,100

201107,200

201108,0

201109,400

201110,500

201111,600

201112,600

];

then in ths front end I get this

Colm	Sales
201104	20
201105	50
201106	100
201107	200
201109	400
201110	500
201111	600
201112	600

Thanks beforehand,

Regards,

Bikash

Sort order

Fri, 26 Aug 2011 05:41:34 GMT

Hi,

This can be achieved by using the below setups

1. Set the Sort order to 'Ascending order'

2. Set the Maximum visible Number to 6 (available in presentation tab)

2. check the option "Reversed" in the presentaion tab