QlikView - First Value with Data, Current and Previous Month Value and Evolution

[Anonymous]

Hi guys,

Related with this thread:

Re: First non null value, regardless selection‌

The below image is what I want to achieve.

Keep the first value of month the same, considering the number of codes with value.

fev: one code with value, so show that value;

mar: two codes with value, so get the first occurrence value for each code, sum it up, and do the average

abr: two codes again, do the same as in mar;

and so one

I think it can help see the image

That's the table I want to achieve.

Keep in mind that I can have hundreds of codes, of I have to get the first occurence for each one.

Thanks again.

Regards,

Sílvia

[sunny_talwar]

Not sure what is the calculation for Evolution, but check out the other ones

[sunny_talwar · Accepted solution]

Forgot to look at the Excel for the expression... Here you go...