Create data MTD AND YTD side by side

[#1]

Hi,

I following data get via select statement.

Key_Account Manger

Customer_Name

Product_description

Invoice_date

Quantity

SalesValue

Our Financial Year Starts from APR to MAR.

Data I need to show will be like.

                                                                                               MTD MTD            YTD   YTD

Key_Account_manager  Customer_Name   Product_description   Qty  SalesValue     QTY   SalesValue

I would like the user to pass the parameter [Month Date]  the system should work out the start from date Apr

I am very new to Qlikview,

[PaulVanSiclen]

a very elegant solution here:

The Magic of Set Analysis - Point in Time Reporting