Discussion Board for collaboration related to QlikView App Development.
I had 2 tables Budget and Sales
where as in budget table having fields like code, jan,Feb,Mar,...,Dec, etc....
Where as in Sales table having fields like code, Date,Sales,etc....
My requirement is to calculate MTD,YTD for sales and Invested_Amount based on Year and Month selections.
I had used Cosstable for Budget and created master calendar based on date field in Sales table.
but when I select year and month MTD for sales given accurate results. but for Invested_Amount not given proper results.
Expected O/P: When selected filters Year = 2019 , Month = Feb