topic Max Month only with Data in QlikView

Max Month only with Data

Mon, 09 Aug 2010 18:15:06 GMT

I want a text box to return the Max(month) or latest month which has data in it.

The problem is when I use the max (month) in always returns 12/Dec because I have loaded in a mapping table with months/dates going out to 2015.

Is there a way of writing my expression such that Max(month) will return only the latest month for which revenues exist?

Thanks in advance!

vgutkovsky — Mon, 09 Aug 2010 21:28:29 GMT

Sure, you can do this with either set analysis or an IF statement. So, for example:


max(if(sum(Revenue)>0,month)

The following set analysis should also work:


max({<month={"=sum(Revenue)>0"}>} month)

Regards,