topic Sorting difficulty in QlikView

Sorting difficulty

Tue, 24 Apr 2012 12:27:37 GMT

Hi I have some difficulties to sort a table. I created an ABC analysis, which workes fine so far. But i need to sort the data based on the revenue of each article. That means the highest revenue of an article on top. As soon as i include a calculation to add up the revenue in another row , the table is not sorted anymore based on revenue. this is the calculation to add up the revenue: =Sum([Summe von PNV]) + if(RowNo()=1,0,Above([Accumulated Revenue])) No matter how i set the "revenue" sorting, ascending or descending, it does not work.It is in a strange order.... regards Jan

Sorting difficulty

SunilChauhan — Tue, 24 Apr 2012 12:30:59 GMT

reemove all selection in sort expression for each dimension

then

check Y value

and select descending

hope this helps

Sorting difficulty

SunilChauhan — Tue, 24 Apr 2012 12:32:06 GMT

reemove all selection in sort expression for each dimension

then

in expression of sort tab write

Sum([Summe von PNV]) + if(RowNo()=1,0,Above([Accumulated Revenue]))

and select descending

hope this helps

Re: Sorting difficulty

Tue, 24 Apr 2012 15:18:51 GMT

Dear Sunil thanks. What do you mean by "check Y value"?

Also I can not add an expession. That field is disabled on the "revenue" value..... 😞

Sorting difficulty

SunilChauhan — Wed, 25 Apr 2012 06:09:06 GMT

in sort at the top a

Y -value sort available

which sort your expression value in ascending or descending order

and for expression when you check the expression check box then it will go enable

hope this helps