topic Re: Ciclic Group From Expression in QlikView

Ciclic Group From Expression

Tue, 12 Jun 2012 08:58:40 GMT

Hi I have a Ciclic Group with 3 values as a Dimension in a Graph, the question is: How can I make to get the current value from the expression. I mean

IF( CICLICGROUP='ValueA', SUM(AmountA), IF(CICLICGROUP='ValueB', SUM(AmountB), SUM(AmountC)))

Thanks in advance.

Re: Ciclic Group From Expression

Sokkorn — Tue, 12 Jun 2012 09:09:46 GMT

Hi Pedro,

I thinks GetCurrentField(GroupName) will do this.

IF(GetCurrentField(GroupName)='ValueA', SUM(AmountA), IF(GetCurrentField(GroupName)='ValueB', SUM(AmountB), SUM(AmountC)))

Please ignore formular checker.

Do let me know if this one help you.

Regards,

Sokkorn

Re: Ciclic Group From Expression

Tue, 12 Jun 2012 09:58:26 GMT

Hi Sokkorn, thanks for your time, I can`t make it work. I don't know why. My Cyclical Group "MadEnv" has 3 posibles values. They are not "real" fields but text Expressions edited while the group was created. Like a list. The values are "Amount", "Kilos" and "UnitPrice".

So the expression should be

IF(GetCurrentField(MadEnv)='Amount',Sum(Amount),
IF(GetCurrentField(MadEnv)='Kilos',Sum(Kilos),Sum(Amount)/Sum(Kilos)))

But It doesn't work. I'm doing something wrong for sure...

Re: Ciclic Group From Expression

Tue, 12 Jun 2012 10:00:07 GMT

What did you mean with "Please ignore formular checker"

Re: Ciclic Group From Expression

Sokkorn — Tue, 12 Jun 2012 11:12:47 GMT

Hi Pedro,

When you apply GetCurrentField(MadEnv) then you will see the red line highlight this epression (normaly it mean wrong expression).

By the way, can you share your app? We look into it together to find solution.

Regards,

Sokkorn

Re: Ciclic Group From Expression

Sokkorn — Tue, 12 Jun 2012 11:33:36 GMT

Hi Pedro,

Let do this

IF(WildMatch(GetCurrentField(MadEnv),'*Amount*'),Sum(Amount),
IF(WildMatch(GetCurrentField(MadEnv),'*Kilos*'),Sum(Kilos),Sum(Amount)/Sum(Kilos)))

Let me know with this expression.

Regards,

Sokkorn

Re: Ciclic Group From Expression

Tue, 12 Jun 2012 11:42:30 GMT

Yeah, the last one worked!! Thank you very much!!