Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Action-Packed Learning Awaits! QlikWorld 2023. April 17 - 20 in Las Vegas: REGISTER NOW
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Set expression not filtering data in Count

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:



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.

Labels (1)
0 Replies