Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Sorting difficulty

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

4 Replies
SunilChauhan
Champion
Champion

reemove all selection in sort expression for each dimension

then

check Y value

and select descending

hope this helps

Sunil Chauhan
SunilChauhan
Champion
Champion

or

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

Sunil Chauhan
Not applicable
Author

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..... 😞

SunilChauhan
Champion
Champion

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

Sunil Chauhan