Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
evansabres
Specialist
Specialist

Script

I have two fields [Expected Send] and 'Opened'

I want to create a field called SentToOpenRate, by dividing 'Opened' by [Expected Send]

Can this be done in the script? If so, what is the proper structure?

1 Solution

Accepted Solutions
m_woolf
Master II
Master II

Opened/[Expected Send] as SentToOpenRate,

If [Expected Send] and be null or zero, you'll need an IF to work around that.

View solution in original post

2 Replies
m_woolf
Master II
Master II

Opened/[Expected Send] as SentToOpenRate,

If [Expected Send] and be null or zero, you'll need an IF to work around that.

aarkay29
Specialist
Specialist

May be this,

[Expected Send] / Opened as Cal