1 Reply Latest reply: Mar 27, 2018 7:50 PM by Petter Skjolden RSS

    Transforming data to create a visualisation

    Yan Foust

      Hi,

      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)

      • Close Date

      2. Monthly ymount (Rolling 12 months weighted)

      • Contract Amount
      • Probability %
      • 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?

       

       

      I'm using Qlik Sense Enterprise through browser.