topic Re: Set Analysis in QlikView

Set Analysis

Tue, 28 Jul 2015 14:33:10 GMT

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

marcus_malinow — Tue, 28 Jul 2015 15:26:07 GMT

Try this:

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

sorrakis01 — Tue, 28 Jul 2015 15:26:26 GMT

Hi,

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

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

Regards

sorrakis01 — Tue, 28 Jul 2015 15:30:04 GMT

Hi,

In your expression you use double cuote

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