Using 2 where conditions in qlik sense

[akankshag]

Hello all, 

Need a little help here.

I have to filter my count according to two where conditions :-

1. enddate should be of yesterday (which is running fine)

2. success_value(column) = 100

I am using following expression :-

=count({$<tbl_backup_snapshot.enddate={">=$(=Date(max(tbl_backup_snapshot.enddate), 'DD/MM/YYYY'))"},tbl_backup_snapshot.success_value={'100'}>}[tbl_backup_snapshot.success_value])

But in output, it is showing as 0 here, which is wrong. Kindly help.

Help would be appreciated

[dplr-rn]

What is the output you get when you do below expression with tbl_backup_snapshot.success_value as dimension.
count({$<tbl_backup_snapshot.enddate={">=$(=Date(max(tbl_backup_snapshot.enddate), 'DD/MM/YYYY'))"}>}