[Set Analysis] Last Month fot which value is not null

[mall1m]

Hi all,

I have several indicator for which I need to calculate through an expression the value for last month for which value is not null

Month	site A	Site B
9	23	111
10	26	127
11	21	140
12	null	155

in the below example,I need to obtain in my graph:

Site A --> 21

Site B --> 155

I manage to get the last month (12)

But I get Site --> null

Site B --> 155

I suppose i could combinate something like max(month where len(my_value)>0) but I don't know how to do that

Does anybody has an idea ?

Thanks in advance

[mall1m · Accepted solution]

I manage to obtain my result through a variable

vLastMonthReported=Max(if(len(my_value)>0 AND len(Month)>0, Month))

and the following set analysis

Month={'=Month=vLastMonthReported'}

[#3]

Hi,

Can you please post a qvw with the example? Because I am looking for the same concept to get it to work but I am not able to reuse your syntax...