Convert date to last 90 days

[cdoshi]

Hi,

I tried to convert time period to 90 days but something is not correct. Could you please help?

='Access : ' & num(sum({<[Request Type]={'ACCESS'}>},{<Date={">=$(=Date(today()-90))<$(=Date(today()))"}>}ALL),'#,##0') & '; '&' Delete : ' & num(sum({<[Request Type]={'DELETE'}>},{<Date={">=$(=Date(today()-90))<$(=Date(today()))"}>}ALL),'#,##0')

[MayilVahanan]

HI @cdoshi

Try like this

='Access : ' & num(sum({<[Request Type]={'ACCESS'},Date={">=$(=Date(today()-90))<$(=Date(today()))"}>}ALL),'#,##0') 

or

='Access : ' & num(sum({<[Request Type]={'ACCESS'},Date={">=$(=Date(today()-90,'YYYY-MM-DD'))<$(=Date(today(),'YYYY-MM-DD'))"}>}ALL),'#,##0') 

Change the date format based on ur date field.

Hope it helps

[Vegar · Accepted solution]

You are a bit vague in your description, try to explaining this "something ". What happens when you use this expression. 

I will, in case of simplicity, focus on one of the two expressions, but you can apply my suggested solution on both your sums.

num(sum({<[Request Type]={'ACCESS'}>},{<Date={">=$(=Date(today()-90))<$(=Date(today()))"}>}ALL),'#,##0')

It seems like you have an extra '>}' and '{<'. Try adjusting to this expression: 

num(sum({<[Request Type]={'ACCESS'},Date={">=$(=Date(today()-90))<$(=Date(today()))"}>}ALL),'#,##0') 

[cdoshi]

Thank you very much ! It worked and sorry for being vague, QlikSense was showing I had a parenthesis issue.