Calculate condition in a chart

[#1]

Hi,

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.

Thanks

[Sokkorn · Accepted solution]

Hi,

Try this SUM(IF(OrderDate = CurrentDate,Amount,0))

Regards,

Sokkorn