topic Re: Make a Calculated Field in Joined Table in QlikView

Make a Calculated Field in Joined Table

rmdnkevin — Fri, 06 Jul 2018 02:24:17 GMT

Hi, everyone.

I have this table view :

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

Re: Make a Calculated Field in Joined Table

sushil353 — Fri, 06 Jul 2018 04:46:25 GMT

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

Re: Make a Calculated Field in Joined Table

rmdnkevin — Fri, 06 Jul 2018 06:24:32 GMT

Here I attach the simulation of the datas.

-Kevin

Re: Make a Calculated Field in Joined Table

Anonymous — Fri, 06 Jul 2018 10:21:32 GMT

Hi Kevin ,

Can you provide your expected result?

Best Regards,

Ashok

Re: Make a Calculated Field in Joined Table

rmdnkevin — Mon, 09 Jul 2018 01:04:32 GMT

Here's the table what I expected :