Conditions for Chart Expression

[RK01923683]

Hi Experts,

I am New to qlik sense.

I am trying to add expression in chart expression 

SUM({<TransactionType={'CI'} , EventDate = {$(Today()-1), 'DD/MM/YYYY'}>} CounterV)

The Expression editor is showing OK for the expression Getting no error but it shows 0 value in result.

If Possible please anyone tell me where i am getting wrong.

I am using this expression on KPI Chart

Thanks in Advance 

Regards,

Rajvir

[Taoufiq_Zarra · Accepted solution]

@RK01923683  maye be :

SUM({<TransactionType={'CI'} , EventDate = {$(=Date(today()-1,'DD/MM/YYYY'))}>} CounterV)

[RK01923683]

That's Correct Thanks much @Taoufiq_Zarra