Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

nevilledhamsiri
Valued Contributor

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
Partner
Partner

Re: Growth over years with the Months passed

The sample qvw is the expected result?

Highlighted
nevilledhamsiri
Valued Contributor

Re: Growth over years with the Months passed

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
Valued Contributor

Re: Growth over years with the Months passed

Can anyone help m on this

 

Thanks

 

Neville

Support
Support

Re: Growth over years with the Months passed

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 don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.
Victor_Alumanah
Contributor

Re: Growth over years with the Months passed

Some useful information here too YTD

While we teach we learn