Discussion board where members can get started with QlikView.
I'm new to Qlikview and i'm trying to calculate a condition in a chart, as follows:
Sum((Amount) if(OrderDate = CurrentDate))
Basically I want to Sum the Sales Amount only if the 2 dates match.
Go to Solution.
Try this SUM(IF(OrderDate = CurrentDate,Amount,0))