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

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

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi guys,

Related with this thread:

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 — Thu, 22 Jun 2017 14:59:34 GMT

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

sunny_talwar — Thu, 22 Jun 2017 15:16:20 GMT

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