limit graph

[qlikviewaf]

Hi ,

i created 2 graph, worst and top 5 customer.

Basically is the delta between sales 2017 and sales 2016.

On both graph i would like to show only positive value and have nothing if a negative value is caluclated.

HOw this can be achieved?

Thank you

[Anil_Babu_Samineni]

Perhaps these?

Worst 5 customers

Sum({<Customer = {"=Rank(-Sum(Sales))<=5"}, Sales = {"=Sum(Sales)>0"}>} Sales)

Top 5 customers

Sum({<Customer = {"=Rank(Sum(Sales))<=5"}, Sales = {"=Sum(Sales)>0"}>} Sales)