find first selected data that have value

[Anonymous]

Hi

I Have a question in bar chart Qlikview.

How can I found first  dimension member in  selected range data that have value grater than Zero?

I want first member of date range that selected and it's value is zero become 0.

[Anil_Babu_Samineni]

Not Really sure what your intend, Perhaps this?

FirstSortedValue(Member, Aggr(Sum({<Measure={"0"}>} Measure), Member))

[sasikanth]

Try,

=FirstSortedValue(Member,  -Aggr(Sum({< Date={">=vMindate <=vMaxdate "}

,  {"=sum(Measure)=0" }>}Measure),Member))

=FirstSortedValue(Member,  -Aggr(Sum({< Date={">=vMindate <=vMaxdate "}

,  {"=sum(Measure)>0" }>}Measure),Member))