Move calculations from expressions to the load script

Thu, 27 Apr 2017 18:10:21 GMT

I need some help to move 13 calculations from a pivot expressions to the load script and to create the 14th calculation that will add the results of previous 12. The formulas works with previous loaded fields and will then be used to create visualizations. I'm attaching some dummy data as reference. Any suggestions will be greatly appreciated.

Re: Move calculations from expressions to the load script

johnca — Fri, 28 Apr 2017 01:12:27 GMT

Hard to say but it looks like you might just take each expression, such as AA below,

=IF(

IsNull([calls - Identifies Reason for Call/Clarifies and Probes (Weight 14pts) *]), '',

IF([calls - Identifies Reason for Call/Clarifies and Probes (Weight 14pts) *]='Meets', 14,

IF([calls - Identifies Reason for Call/Clarifies and Probes (Weight 14pts) *]='Missed', 0,

IF([calls - Identifies Reason for Call/Clarifies and Probes (Weight 14pts) *]='NA',''))))

and place it into the script in a preceding load statement to your table and give it a field name, one for each expression, a la;

IF(

IsNull([calls - Identifies Reason for Call/Clarifies and Probes (Weight 14pts) *]), '',

IF([calls - Identifies Reason for Call/Clarifies and Probes (Weight 14pts) *]='Meets', 14,

IF([calls - Identifies Reason for Call/Clarifies and Probes (Weight 14pts) *]='Missed', 0,

IF([calls - Identifies Reason for Call/Clarifies and Probes (Weight 14pts) *]='NA','')))) as AA

Then, in a preceding preceding load add the new fields together, a la;

AA + Ab + AC... as Combined

I would start this way.

topic Re: Move calculations from expressions to the load script in QlikView

Move calculations from expressions to the load script

Re: Move calculations from expressions to the load script