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

[salil1616]

Hello:

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

[Brett_Bleess]

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

https://community.qlik.com/t5/Qlik-Design-Blog/Slowly-Changing-Dimensions/ba-p/1464187

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.

Regards,
Brett