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'