Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
New Contributor

As of Table Logic for Rolling 12 Months with multiple fact tables


I have been trying to implement As of Month Logic to get Rolling 12 Month Gross Margin and Rolling 12 Month Average INV value but not completely successful yet. I have 3 tables I am trying to get data. Gross Margin(GM) Net Revenue(NR) Table that has data at date level, Monthly GM NR Table that has Monthly GM and Monthly NR and Monthly Inventory Table has data at Monthly level. My Problem is I have Missing Months in Monthly GM NR Table and Monthly Inventory Table that is messing my final calculation of (Rolling 12 Month GM / Rolling 12 Month Avg. Inventory Value)


Thank you

1 Reply

Re: As of Table Logic for Rolling 12 Months with multiple fact tables

Salil, the best I have for you is a link to the Design Blog area that I think might help to a degree.  Feel free to back things up to the Qlik-Design-Blog/ of the URL and use that to do some further searching on your own there.  There are hundreds of posts out there on specific topics that I suspect may be what you need, I am just not quite sure which other ones you may need here.  I generally start the search with a single word and see what I get back there and use those results to hone my query to try to find what I actually need...


Hopefully this may get you a little further, and my posting will kick this back up to the top of things too, so perhaps someone else may also chime in too.


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.