topic find first selected data that have value in QlikView

find first selected data that have value

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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 — Thu, 05 Jul 2018 03:54:11 GMT

Not Really sure what your intend, Perhaps this?

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

sasikanth — Thu, 05 Jul 2018 05:37:28 GMT

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))