Discussion Board for collaboration related to QlikView App Development.
I am very new to Qlik so I apologize if this is a basic questions
I have a table like the one below
But the table does not have the expenses for the current year (2018), which is stored in a different table broken out by quarter.
I am able to get a temp table with the the sum of the quarterly expenses by project with this:
[Expense Pool] as [ Expense Pool temp],
sum([Expense]) as [Expense temp],
group by [Project ID],[Expense Pool]
How can I now get my total yearly expense into TableA for the year 2018?