I'm new to Qlik Sense and I need to create a visualisation in Qlik Sense but I need to create new dimensions based on certain data and criteria.
1. Days to Close (number of days until close date in buckets >60 days, 30-60 days, <30 days)
2. Monthly ymount (Rolling 12 months weighted)
Contract Start Date
Contract End Date
I need to see this data in tables and in a chart. I understand it is not possible to use a calculated field in an expression so I guess the way to go is to write 1 expression for each and replicate it in each table and chart?