Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
matKa
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:

=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.

Labels (1)
0 Replies