topic Re: why after add accumulated col my sales column unable to sort from hi to lo ? in QlikView

why after add accumulated col my sales column unable to sort from hi to lo ?

Tue, 10 Dec 2013 11:55:50 GMT

Hi All

I notice some thing very funny. hope some one can share with me why this happen ?

Before add Accumulated sales , sales Column is sort from high to low , ( see table 1 ) . Why after add the Accumulated sales , Sales column is not sort from high to low ? ( See Table 2)

See the enclosed QV doc.

Re: why after add accumulated col my sales column unable to sort from hi to lo ?

Clever_Anjos — Tue, 10 Dec 2013 12:17:39 GMT

Everytime you use Rowno() or Rank() into a expression this 'bugs' sorting.

Use the feature of "Full Acumulation" instead

Re: why after add accumulated col my sales column unable to sort from hi to lo ?

Tue, 10 Dec 2013 12:25:29 GMT

you are so clever .