topic Re: Add / Make a Calculated Field in QlikView

Add / Make a Calculated Field

rmdnkevin — Wed, 25 Nov 2020 16:16:04 GMT

Hi, everyone.

I have a table view like this :

And I need to make a field when I joining those 2 tables with this expression :

(Count( {<status={'Email Sent'}>} status) + Count( {<status={'Email Opened'}>} status) + Count( {<status={'Clicked Link'}>} status) + Count( {<status={'Submitted Data'}>} status)) ; CountofEmailSent as the name of new field

How can I make a calculated field with that expression ?

Thank you

- Kevin

Re: Add / Make a Calculated Field

Anil_Babu_Samineni — Fri, 06 Jul 2018 03:10:38 GMT

Why you want to have in script? instead UI is easy to do. And that too Set analysis won't consume much performance.

Re: Add / Make a Calculated Field

sunny_talwar — Fri, 06 Jul 2018 13:12:04 GMT

And you want to do this in the script? Can you share some raw data and provide what do you wish to see as an expected output?

Re: Add / Make a Calculated Field

neelamsaroha157 — Fri, 06 Jul 2018 13:21:58 GMT

May be you can create an additional table in your model as

Load PrimaryKeyField

Count(PrimaryKeyField)

Resident 20180612

where Match(Status, 'Email Sent', 'Email Opened','Clicked Link','Submitted Data')

group by PrimaryKeyField;

Replace PrimaryKeyField with ID or ID+Date field.

You can simply create a flag for all the mentioned status and count them in front end.