Set expression not filtering data in Count

matKa — Fri, 11 Feb 2022 13:17:11 GMT

1. I try to do simple count if text_date (text format) is the same as a variable Max_Date (Date format). When I convert them both with num() in the table and I compare them than it gives correct results. But when I want to have a KPI with count based on this condition it's not filtering at all:

=Count({<"=num(date(date#(text_date,'DD/MM/YYYY')))" = {"=Num(Max_Date)"}>}distinct [mvp])

Max_Date formula:

=Date(Max(num(date(date#(text_date,'DD/MM/YYYY')))))

2. Additionally if I change text_date in filters I get different value for Max_Date. I've read that you have to put {1} in the formula but I don't know where.

topic Set expression not filtering data in Count in QlikView

Set expression not filtering data in Count