Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Highlighted
inigoelv
Contributor

EXPRESSION WITH CONDITION IN SET ANALISYS

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,

2 Replies
MVP & Luminary
MVP & Luminary

Re: EXPRESSION WITH CONDITION IN SET ANALISYS

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))))


talk is cheap, supply exceeds demand
MVP & Luminary
MVP & Luminary

Re: EXPRESSION WITH CONDITION IN SET ANALISYS

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))))