Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Not Really sure what your intend, Perhaps this?
FirstSortedValue(Member, Aggr(Sum({<Measure={"0"}>} Measure), Member))
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))