Using 2 where conditions in qlik sense

akankshag — Sat, 16 Nov 2024 05:13:55 GMT

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

Re: Using 2 where conditions in qlik sense

dplr-rn — Fri, 19 Jul 2019 18:13:35 GMT

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'))"}>}

topic Using 2 where conditions in qlik sense in App Development

Using 2 where conditions in qlik sense

Re: Using 2 where conditions in qlik sense