Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

How to sum of sales over specified period dynamically

Hi,

This is regarding set analysis query. I have a Orders table whic contain contain order details,sales amount and date key. I have another date table.The order table and date table are joined with the help of date key. I need to find the sum of sales amount over a range. From Year and To Year parameters need to be added in the report. The sum of sales have to be calculated based on the From Year and To year parameters. Can any one let me know how it can be implemented!!

Thanks!

Surendra

Community Browser