Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

set analysis problem

I have a set analysis problem in qlikview.
I want to find the max date and filter the dates before 7 days (after today()-7).

this is the field i tried to manipulate:

fva_day_id

20140901

20150801

20141011


and this is the code:

=
text(Date(Date#(max(

{$<
num(Date(today()),'#####')-num(Date(Date#(max(fva_day_id),'YYYYMMDD'))) > 7  > }

fva_day_id),'YYYYMMDD'))) &' EST'

There is a syntax error in the code.

The results should look like this (but without dates before 7 days):

Can somebody help me to find the syntax error?

Thanks

1 Reply
ramoncova06
Partner - Specialist III
Partner - Specialist III

you only want to show the dates ?

only ({<fva_day_id = {>=$(NUM(TEXT(date(today()-7),'YYYYMMDD')))}>}date(date#(fva_day_id,'YYYYMMDD'),'YYYY-MM-DD'))&''&' EST'