Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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'}
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'}
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...