How to preload past 7 days record in inline table for QilkSense Windows

[letqi]

I am new to Qliksense application.

I am trying to autoload/preload the past 7 days data in inline table format using set analysis and not script. However, under my data field expression, Sum({$<DateField1={"<=Date(today(), 'YYYY-MM-DD')"}>} DateField2) , i am facing invalid dimension entered. Can anybody advice me on this? OR are there any other ways to do this without writing script?

Trying to display past 7 days record in my inline table using Dated records.

DateField1 and DateField2 are both different data column variables in the inline table 

[Digvijay_Singh · Accepted solution]

Try this, Hope DateField1 is a correct field name and its format is YYYY-MM-DD

Sum({$<DateField1={"<=$(=Date(today(), 'YYYY-MM-DD'))"}>}DateField2)

[letqi]

its shows Error in expression: ')' or ',' expected

[Digvijay_Singh]

Can you share image of expression editor having the expression and the bottom section of expression editor where it shows the set expression expanded..

[letqi]

i tried this and the expression is OK however my output is invalid dimension. 

[letqi · Accepted solution]

yes it works, 

Sum({$<DateField1={"<=$(=Date(today() -7, 'YYYY-MM-DD'))"}>}DateField2

or 

in UI,

If ( DateField1 >= Date(Today()-7, 'YYYY-MM-DD' ), DateField1 ) 

Filter DateField1 to show past 7 months records.