Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
RK01923683
Contributor II
Contributor II

Conditions for Chart Expression

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

Labels (4)
1 Solution

Accepted Solutions
Taoufiq_Zarra

@RK01923683  maye be :

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

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉

View solution in original post

2 Replies
Taoufiq_Zarra

@RK01923683  maye be :

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

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
RK01923683
Contributor II
Contributor II
Author

That's Correct Thanks much @Taoufiq_Zarra