Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
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
sorrakis01
Valued Contributor

Re: Set Analysis

Hi,


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

/

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

Regards

3 Replies
marcus_malinow
Valued Contributor III

Re: Set Analysis

Try this:

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

sorrakis01
Valued Contributor

Re: Set Analysis

Hi,


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

/

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

Regards

sorrakis01
Valued Contributor

Re: Set Analysis

Hi,

In your expression you use double cuote

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

Community Browser