Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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')
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')
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
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')
Thank you very much ! It worked and sorry for being vague, QlikSense was showing I had a parenthesis issue.