topic limit graph in QlikView

limit graph

qlikviewaf — Mon, 06 Nov 2017 16:46:09 GMT

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 — Mon, 06 Nov 2017 16:53:43 GMT

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)