topic Re: help in expression in QlikView

help in expression

ali_hijazi — Wed, 10 Dec 2014 13:22:03 GMT

hello

got a bar chart with dimension MonthYear (e.g. Jan-2014, Feb-2014)

the expression is sum(Sales)

ok I select the year 2014

and I get sales for the following months Jan, Feb, April

what I want now is get the last month that has sales in the above chart

how can I get the value of Apr-2014 from the sum(sales)

Wed, 10 Dec 2014 14:18:10 GMT

Please try this:

sum({1<MonthYear ={$(=max(MonthYear ))} Sales)

ali_hijazi — Wed, 10 Dec 2014 15:04:20 GMT

I was thinking of using firstsortedvalue

but could not get any result

simenkg — Wed, 10 Dec 2014 15:07:05 GMT

sum({<MonthYear ={"$(=max(MonthYear ))"} Sales)

This will give you sales in the last possible MonthYear in the selection.

ali_hijazi — Wed, 10 Dec 2014 15:17:58 GMT

max(MonthYear) gives Dec-2014 and this is not the case

i found this maxString({<MonthYear={"=sum(Sales)>0"}>}Sales)