topic Re: [Set Analysis] Last Month fot which value is not null in QlikView

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

mall1m — Fri, 18 Jan 2013 08:01:11 GMT

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

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 — Fri, 18 Jan 2013 09:39:48 GMT

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'}

Fri, 14 Jun 2013 11:42:13 GMT

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