topic Re: EXPRESSION WITH CONDITION IN SET ANALISYS in QlikView

EXPRESSION WITH CONDITION IN SET ANALISYS

inigoelv — Tue, 04 Aug 2015 22:34:11 GMT

Hi everybody:

I need help to include one condition into a set analysys.

I have one expression that shows only one value:

Min(Total <Description> fabs([€/Ton]*(1+Merma/100)*Aggr((Gramaje)-Avg([Grammage calculado (gr/m2)]),Description,Paper)))

and I would like to include into this expression like a filter in this expression:

MinRM=Min([€/Ton]*(1+Merma/100))

Is it possible?

Thanks in advance

Best regards,

Re: EXPRESSION WITH CONDITION IN SET ANALISYS

Gysbert_Wassenaar — Wed, 05 Aug 2015 06:03:24 GMT

Maybe like this:

If(MinRM=Min([€/Ton]*(1+Merma/100)),Min(Total <Description> fabs([€/Ton]*(1+Merma/100)*Aggr((Gramaje)- Avg([Grammage calculado (gr/m2)]),Description,Paper))))

Re: EXPRESSION WITH CONDITION IN SET ANALISYS

jagan — Wed, 05 Aug 2015 06:24:26 GMT

Hi,

Try like this

If(MinRM=Min([€/Ton]*(1+Merma/100)), Min(Total <Description> fabs([€/Ton]*(1+Merma/100)*Aggr((Gramaje)-Avg([Grammage calculado (gr/m2)]),Description,Paper))))