QlikView - evaluate expression in chart object

[agigliotti]

Hello,

I have a pivot table with a dynamic expression as below:

if( t01_dims_y._field = 'FRC min',

'Min(',

if( t01_dims_y._field = 'FRC med',

'Avg(',

if( t01_dims_y._field = 'FRC max',

'Max(' ) ) )

& 'Aggr(' &

if( t01_dims_x._field = 'RCV',

'sum(MovimIndustriale.ImportoUdc)',

if( t01_dims_x._field = 'CST',

'sum(1)' ) )

& ', %CodCommessa ))'

it give me a valid expression as string.

How does is possible to evaluate it ?

Before I was trying the below expression but it doesn't works and I don't understand why:

if( t01_dims_y._field = 'FRC min' and t01_dims_x._field = 'RCV',

Min( Aggr( sum(1), %CodCommessa ) ),

if( t01_dims_y._field = 'FRC max' and t01_dims_x._field = 'RCV',

Max( Aggr( sum(1), %CodCommessa ) )

))

without using Aggr function it works !?

the same behaviour occurs also using ValueList as dimension.

Thanks in advance for your help.

Best regards

Andrea

[sunny_talwar]

Might be easy to see if you can share a sample

[agigliotti]

attached the sample app.

[sunny_talwar]

I am not entirely sure, but may be this?

If(t01_dims_y._field = 'FRC min' and t01_dims_x._field = 'RCV',

Num(Min(Aggr($(vL.Budget.Ricavi), %CodCommessa, t01_dims_x._field, t01_dims_y._field)), '€ #.##0;-€ #.##0'),

If(t01_dims_y._field = 'FRC med' and t01_dims_x._field = 'RCV',

Num(Avg(Aggr($(vL.Budget.Ricavi), %CodCommessa, t01_dims_x._field, t01_dims_y._field)), '€ #.##0;-€ #.##0'),

))

[agigliotti]

with data reduced app it works as expected.

I attached also the same app with all data and there the same expression doesn't works.

it's a shame!

but why?

[sunny_talwar]

Add TOTAL

If(t01_dims_y._field = 'FRC min' and t01_dims_x._field = 'RCV',

Num(Min(TOTAL Aggr($(vL.Budget.Ricavi), %CodCommessa, t01_dims_x._field, t01_dims_y._field)), '€ #.##0;-€ #.##0'),

If(t01_dims_y._field = 'FRC med' and t01_dims_x._field = 'RCV',

Num(Avg(TOTAL Aggr($(vL.Budget.Ricavi), %CodCommessa, t01_dims_x._field, t01_dims_y._field)), '€ #.##0;-€ #.##0'),

))

[agigliotti]

the results are wrong.

if you create a text object with the below expressions you can see the right results.

Num(Min(Aggr($(vL.Budget.Ricavi), %CodCommessa )), '€ #.##0;-€ #.##0')

Num(Avg(Aggr($(vL.Budget.Ricavi), %CodCommessa )), '€ #.##0;-€ #.##0')

[sunny_talwar]

Not entirely sure, but when I try them in the text object... they seem to match with what I have in the table

[agigliotti]

here in text box you find the correct results.

[sunny_talwar]

What expressions did you use? oh... you might have used the ones without the total, right?

[agigliotti]

yes of course.