Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
nevilledhamsiri
Specialist
Specialist

Growth over years with the Months passed

Hi Members

I need the growth to be calculated as done in the table. But for the growth in 2019, it should be done as follows:

take 9 Months Average from 2018 & compare it 2019 figure which is almost for Nine months data. How this could be done. This is a simple data array. But I need to apply this logic for heavy data set with plenty of dimensions over different Years

 

Thanks

Neville

 

5 Replies
Arthur_Fong
Partner - Specialist III
Partner - Specialist III

The sample qvw is the expected result?

nevilledhamsiri
Specialist
Specialist
Author

Dear Jkfong93,

I am working on personnel edition which makes me impossible to open up your qvd. Could you please send me your expressions on the body of the mail/message

 

Thanks a lot

nevilledhamsiri
Specialist
Specialist
Author

Can anyone help m on this

 

Thanks

 

Neville

Brett_Bleess
Former Employee
Former Employee

Neville, have a look in the Design Blog area, the below URL is the base location, use the search dialog to try to narrow the list etc.  Off the top of my head, I could not really think of any direct posts that would work, but I think if you search around, you may find some examples of things that will give you some ideas that should work.

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
Victor_Alumanah
Creator
Creator

Some useful information here too YTD

While we teach we learn