Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Highlighted
MarkTash
New Contributor

Date subtraction

=if(Dimensionality()=max(Dimensionality()),

if(Count({<[Transactions.Txn Type]={"Invoice"},Transactions.Pending={0},[Transactions.Txn Date]={">=$(=YearStart(vDate))"}>} DISTINCT [Transactions.Txn ID])>0,

If(Count({<[Transactions.Txn Type]={"Invoice"},Transactions.Pending={0},[Transactions.Txn Date]={"<=$(=YearEnd(vDate,-1))"}>}
DISTINCT [Transactions.Txn ID])=0,

'New',

'Current'),

if(Count({<[Transactions.Txn Type]={"Invoice"},Transactions.Pending={0},[Transactions.Txn Date]={"<=$(=YearEnd(vDate,-1))"} >}
DISTINCT [Transactions.Txn ID])>0,

'Lost',

'Never Ordered')))

 

In the enclosed Formula I have been able see if the Year Value is less by 1 year, but what i really want is to see if the change in one year by date not year from the transaction date so so 3/28/2018 to make sure it is 3/30/2017 is still Under year were 3/27/2017 is not.

Labels (2)