Skip to main content
Announcements
Qlik Community Office Hours - Bring your Ideation questions- May 15th, 11 AM ET: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Adding Dates Example only transactions for 2017

How do I had a date?   example 2017 transactions only

sum (If (Transactions.Pending = 0 or IsNull(Transactions.Pending), if ([Transactions.Cost Or Revenue] = 'Act Cost' and (Match ([Transactions.Txn Type], 'Inventory Adjustment')

  or (Match([Transactions.Classified Account Type], 'Income'))), -[Transactions.Amount With Sign],

   if([Transactions.Cost Or Revenue] = 'Act Cost' and Match([Transactions.Classified Account Type], 'Liability'),-[Transactions.Amount With Sign],

    if ([Transactions.Cost Or Revenue] = 'Act Cost', [Transactions.Amount With Sign], 0)))))

2 Replies
Anil_Babu_Samineni

Perhaps this?

sum (If ((Transactions.Pending = 0 or IsNull(Transactions.Pending)) and Year = 2017, if ([Transactions.Cost Or Revenue] = 'Act Cost' and (Match ([Transactions.Txn Type], 'Inventory Adjustment')

  or (Match([Transactions.Classified Account Type], 'Income'))) and Year = 2017, -[Transactions.Amount With Sign],

   if(([Transactions.Cost Or Revenue] = 'Act Cost' and Match([Transactions.Classified Account Type], 'Liability')) and Year = 2017,-[Transactions.Amount With Sign],

    if ([Transactions.Cost Or Revenue] = 'Act Cost' and Year = 2017, [Transactions.Amount With Sign], 0)))))

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Anonymous
Not applicable
Author

Doesn't work. still trying to create