# QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Rules, plus terms and conditions, can be found here.
Not applicable

## Set Analysis

Hi Guys/Girls

I want to create a set analysis like such with a calculation at the end: so I set the producer group, but for that set i want to do a calculation

sum({\$<[Producer Group] = {"Pool"}>}FOB?EXW/[Standard Carton Equivalent])

But that does not work...

Any help will be appreciated

Regards

Andre

Tags (1)
1 Solution

Accepted Solutions
Valued Contributor

## Re: Set Analysis

Hi,

sum({\$<[Producer Group] = {'Pool'}>}[FOB?EXW])

/

sum({\$<[Producer Group] = {'Pool'}>}[Standard Carton Equivalent])

Regards

3 Replies
Valued Contributor III

## Re: Set Analysis

Try this:

sum({\$<[Producer Group]={"Pool"}>} [FOB?EXW]/[Standard Carton Equivalent])

Valued Contributor

## Re: Set Analysis

Hi,

sum({\$<[Producer Group] = {'Pool'}>}[FOB?EXW])

/

sum({\$<[Producer Group] = {'Pool'}>}[Standard Carton Equivalent])

Regards

Valued Contributor

## Re: Set Analysis

Hi,

In your expression you use double cuote

sum({\$<[Producer Group] = {'Pool'}>}FOB?EXW/[Standard Carton Equivalent])