Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Streamlining user types in Qlik Cloud capacity-based subscriptions: Read the Details
cancel
Showing results for 
Search instead for 
Did you mean: 
MarkTash
Contributor
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 (1)
0 Replies