topic Re: Adding Dates Example only transactions for 2017 in QlikView

Adding Dates Example only transactions for 2017

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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)))))

Re: Adding Dates Example only transactions for 2017

Anil_Babu_Samineni — Fri, 01 Jun 2018 03:07:14 GMT

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)))))

Re: Adding Dates Example only transactions for 2017

Anonymous — Sun, 03 Jun 2018 18:55:03 GMT

Doesn't work. still trying to create