Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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

Hi guys,

Related with this thread:

Re: First non null value, regardless selection

The below image is what I want to achieve.

expected_2.png

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

1 Solution

Accepted Solutions
sunny_talwar

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

Capture.PNG

View solution in original post

2 Replies
sunny_talwar

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

Capture.PNG

sunny_talwar

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

Capture.PNG