Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

Editing Cells in a resident table QlikSense

I am very new to Qlik so I apologize if this is a basic questions

I have a table like the one below

TableA:

IDYearRevenueExpense PoolExpense
1201812A-
1201913A2
1202012A3

But the table does not have the expenses for the current year (2018), which is stored in a different table broken out by quarter.

TableB

IDExpense PoolQuarterExpense
1A1.5
1A2.2
1A3.3
1A4.6

I am able to get a temp table with the the sum of the quarterly expenses by project with this:

TableBTemp:

LOAD

    [ID],

    [Expense Pool] as [ Expense Pool temp],

    sum([Expense]) as [Expense temp],

Resident TableB

group by [Project ID],[Expense Pool]

;


How can I now get my total yearly expense into TableA for the year 2018?

0 Replies