How to add data/value in the expression?

Anonymous — Wed, 11 Jun 2014 08:36:14 GMT

Hi, QV community

I need to some help to add data in the expression (not in the script).

I have an example for you guys to see.

I will talk about the example because you understand better if you look at it.

First take a look at the example before read my explanation.

One Job Number (AARS10) which is the same number as the console Job has information about the cost and Container Type.

The other Job Numbers (AARS11 and AARS12) have information about the revenues and nothing about the container type as you can see in the data below

I need the to get the same Container Types value in all my jobs. So when I filter Container Type "40HC" I will get all the jobs not only AARS10.

I try to use this formula to add the data in the container type

=aggr(MaxString(TOTAL <[Console Job]> [Container Type]),[Console Job],[Job number])

It worked but created a problem for Console Job IMMS10 becuase it has many different Container Types.

How can I do make an formula in the chart properties to get the solution I want

Any ideas?

Re: How to add data/value in the expression?

Wed, 11 Jun 2014 11:19:09 GMT

Góðan daginn!
Something like this maby?

if(aggr(count([Container Type]),[Console Job],[Job number])=1,MaxString(TOTAL <[Console Job]>[Container Type]),[Container Type])

Not sure if it sovles it for you but you can try something similar.

Kind Regards from Sweden

Gysbert_Wassenaar — Wed, 11 Jun 2014 12:08:26 GMT

See attached qvw

Anonymous — Wed, 11 Jun 2014 13:54:57 GMT

Takk, Fjalar

it worked the way I wanted

kind regards from Iceland