Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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'