how to add extra values to the dimension field?

[Akina0929]

Hi,

I have a job field it consist some values, i want to add some more  values to job field how can i add .

Thanks

Anji

[qlikview979 · Accepted solution]

Hi,

As per my knowledge  create Inline table with values and add it to the main table

[qlikview979]

like this

T1:

LOAD Product, ////product having P1,P2,P3

     Sales

FROM

(ooxml, embedded labels, table is Sheet2);

Concatenate(T1)

T2:

LOAD * Inline [

Product

P4

P5

P6

P7

];

Result:-

Product,Sales

P1,100

P2,200

P3,300

P4,-

P5,-

P6,-

P7-

[Akina0929]

Thank you mahesh

[qlikview979]

Hi Anji,

if you receive the correct answer,please mark it as correct answer,may be in future this is help full for others.

Regards

[qlikview979]

Good

[lwileczek]

Is there away to assign values to the added dimensions? e.g.
P4 is the sum of P1-P3
P5 is the mean of P1-P3