topic Re: aggr? in QlikView

aggr?

n1ef5ng1 — Wed, 19 Jun 2013 11:19:07 GMT

I have this two field, Destination and Arrival.

However, I am using cyclic group to split this two.

is there any way I can create a new field for the total of destination and arrival?

is it by using aggr function to find?

I am unable to use this two field in a table due to complex calculation.

sujeetsingh — Wed, 19 Jun 2013 11:25:57 GMT

How you want to combine the two fields ?

What chart you are using ?

Can you please give a sample ?

Wed, 19 Jun 2013 11:50:36 GMT

I think you make a new field for the total of destination and arrival

the try this

destination + arrival as newfield

n1ef5ng1 — Thu, 20 Jun 2013 03:21:06 GMT

This is my expression to find Destination,

=if( MonthEnd ( MAX( Date ) ) <> var_EndDate AND MonthEnd( MAX ( Date ) )
= MonthEnd( var_EndDate ) ,

Sum({<
Derived_Status -= {'LRSHP'}
>} TEU / Day( var_EndDate )) * Day(MonthEnd(MAX ( Date )))

((sum({$<Derived_Status -= {'LRSHP'}>} TEU) )))

So my expressionshould be

sum( aggr(

if( MonthEnd ( MAX( Date ) ) <> var_EndDate AND MonthEnd( MAX ( Date ) )

= MonthEnd( var_EndDate ) ,

Sum({<
Derived_Status -= {'LRSHP'}
>} TEU / Day( var_EndDate )) * Day(MonthEnd(MAX ( Date )))

((sum({$<Derived_Status -= {'LRSHP'}>} TEU) )))

,Destination ,Arrival)) ?

n1ef5ng1 — Thu, 20 Jun 2013 03:22:17 GMT

destination and arrival are derived from two different table? how can i combine this two as newfield

Thu, 20 Jun 2013 03:48:24 GMT

We couldn't understand your tablestructure and requirement. Could you send samle file?

Karthik