How to add data/value in the expression not in the script

[Anonymous]

Hi, QV community

I need to some help to add data in the expression.

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

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.

My it is possible to use the Consol Job number

Any ideas?

[#2]

Temp:

LOAD [Console Job],

     [Job number],

     Revenue,

     Cost,

     Container,

     if([Job number] = [Console Job], [Container Type], Peek([Container Type])) as [Container Type]    

FROM

[Example QV.xlsx]

(ooxml, embedded labels);

This should work for you.

[#3]

Here is the new qvw as well.

[Anonymous]

Thanks for the respond.

Your answer is what I am looking for but can I do it in the chart properties and not in the edit script.

The reason is because I do not want to AARS11 and AARS12 to have "40HC" every time just only in curtain charts that I can choose

[#5]

The only thing I can think of is to make another field in the load script:

Temp:

LOAD [Console Job],

     [Job number],

     Revenue,

     Cost,

     Container,

     [Container Type] as ContainerChoice,

     if([Job number] = [Console Job], [Container Type], Peek([Container Type])) as [Container Type]    

FROM

[Example QV.xlsx]

(ooxml, embedded labels);

ContainerChoice is the original excel field. Container Type is the new field.

[Anonymous]

ok, you do not know how to make the same order as

if([Job number] = [Console Job], [Container Type], Peek([Container Type])) as [Container Type]  

I do not know how to make that order in chart properties in the add calculated dimension or expression