Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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

Tags (2)
4 Replies
chauhans85
Esteemed Contributor

Sorting difficulty

reemove all selection in sort expression for each dimension

then

check Y value

and select descending

hope this helps

chauhans85
Esteemed Contributor

Sorting difficulty

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

Not applicable

Re: Sorting difficulty

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..... Smiley Sad

chauhans85
Esteemed Contributor

Sorting difficulty

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

Community Browser