Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Last 10 Items!

Hi All,

Using the below I used to find the Top 10 ranking items along with this FSName is also there in the dimension field which is used to display the FSName. In the expression field I used Sum(Value) to show the value of the Top 10 items.

Same thing I want to do for the Last 10 items. Don't know exactly what changes I have to do in the below script. Can some one please help me out to do the same.


=IF(
aggr(
rank(total
aggr( sum(Value),FSName)
,0,1)
,FSName)
<=10,

aggr(
rank(total
aggr( sum(Value),FSName)
,0,1)
,
FSName))


6 Replies
MVP
MVP

Last 10 Items!

Just change the sign: -sum(Value)

Not applicable

Last 10 Items!

Hi John,

I already tried with that. In that case it shows only the -ve value. It is not showing up the positive values. In my application sales value contain both +ve as well as -ve values.

Have attached the actual and expected result below.

Actual:

Expected:

Not applicable

Last 10 Items!

Hi John,

What is the use of -ve sign before Sum(Value). First of all I thought it sort the value from lowest to highest. Later when checked realized that it doesn't do that. So could you please for what purpose we are putting -ve sign before Sum(Value).

Thanks in advance

MVP
MVP

Last 10 Items!

Please post an example with the problem, then. As should be obvious, flipping the sign will reverse the rankings. And unless there's a bug I'm not aware of, reversing the ranking by flipping the sign should not prevent positive values from showing.

Not applicable

Last 10 Items!

Hi John,

Thanks for explaining me the use of -ve sign before sum. By the way as requested I have attached the document for you to work with. Hope the issue will be understandable now.

MVP
MVP

Last 10 Items!

Rikab

If you turn off the suppress zero value option in the Presentation tab of your Last 10 FS's and your Sales Value for Reference tables, you will see that there are a number of FSNames with value of zero. These all tie for 3rd place when ranking the bottom 10.

That explains why you only see two when zeroes are suppressed.

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Community Browser