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

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
MVP

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

Community Browser