Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Make a Calculated Field in Joined Table

Hi, everyone.

I have this table view :

Screenshot_11.png

The contents from status field on 20180612 table are Email Sent, Email Opened, Clicked Link, Submitted Data.

I need to make a join table with fields are : Date, CountofEmailSent, CountofEmailOpened, CountofClickedLink, and CountofSubmittedData

with the example of expression from CountofClickedLink = sum of Clicked Link + sum of Submitted Data from status field on original table.

How can I do that ?

Thank you

-Kevin

4 Replies
Highlighted
Master II
Master II

Hi Kevin,

Your issue is not clear by the statement : with the example of expression from CountofClickedLink = sum of Clicked Link + sum of Submitted Data from status field on original table.


It is better if you can attach a sample qvw.


HTH

sushil

Highlighted
Contributor III
Contributor III

Here I attach the simulation of the datas.

-Kevin

Highlighted
Contributor II
Contributor II

Hi Kevin ,

Can you provide your expected  result?

Best Regards,

Ashok

Highlighted
Contributor III
Contributor III

Here's the table what I expected :

Screenshot_12.png