Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

yan_foust
New Contributor

Transforming data to create a visualisation

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.

1 Reply
Highlighted
MVP
MVP

Re: Transforming data to create a visualisation

You can use calculated fields in expressions - so you will not need to do anything special replication or other things at all.