set analysis problem

Wed, 18 Mar 2015 16:52:15 GMT

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

Re: set analysis problem

ramoncova06 — Wed, 22 Jul 2015 23:52:31 GMT

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'

topic set analysis problem in QlikView

set analysis problem

Re: set analysis problem