topic Re: How to fix this IF condition? in QlikView

How to fix this IF condition?

Tue, 30 Jul 2013 09:51:22 GMT

Hello,

Please, how to fix the expression below?

if (UF = 'EX' and ProductMaterial = min(Color_id), sum (costmat))

ProductMaterial = min (Color_id) is not working.

I need to pick up just the first color number from each material and from each product.

Product

Color_id

ProductMaterial

Cost

Thanks.

er_mohit — Tue, 30 Jul 2013 09:59:15 GMT

try this

for min color id

aggr( min (Color_id),ProductMaterial)

or try this way

ONLY({<Color_id = {"=min (Color_id)"}>}ProductMaterial)

sum({<UF={'EX'},Color_id={"=MIN(Color_id)"}>}costmat)

Tue, 30 Jul 2013 09:59:44 GMT

try this

if (UF = 'EX' and Color_id = Aggr(min(Color_id),ProductMaterial), sum (costmat))

or try this

try this

if (UF = 'EX' and Color_id = min(Color_id), sum (costmat))

Tue, 30 Jul 2013 10:07:36 GMT

in script--

load

min(Color_id) as min

from table group by ProductMaterial;

the try your syntax

Tue, 30 Jul 2013 13:03:02 GMT

Thanks very much for everyone!... the expression below fits well:

if (UF = 'EX' and Color_id = Aggr(min(Color_id),ProductMaterial), sum (costmat))