show last seven days date in graph in qlik sense

[MMCGLAESASAA]

Hi All,

I am stuck in one formula can any body help me please. I need to show last seven days dates in bar graph based on current date.

[NitinK7]

try

EXP-  Sum({<Date={"<=$(=Day(today()))>=$(=Day(today())-7)"}>}amount)

[MMCGLAESASAA]

Not working please see the below image. Showing invalid value. 

[NitinK7]

could you attach here your sample data

[MMCGLAESASAA · Accepted solution]

Hi got the solution

i make a field in load editor If(WeekDay(TempDate)<>'Sun',IF(TempDate>=(TODAY()-8)and(TempDate <TODAY()),'Last 7',''),'') as Sevenday      and then i make measure =Date(If(Sevenday='Last 7',CallDate,''),'MM/DD')

and it works for me thank you.