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

Announcements
Join us in Toronto Sept 9th 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