Merge fields in one dimension

[Anonymous]

Good evening everyone,
i am new of Qlikview and I apologize in advance for my poor English. Now my problem!

I have a dimension called DescAsaBreve that contains a series of name/text values (ex. x, y, z, u). I would like to create a new value calculated, always in the same dimension DescAsaBreve, i called k, made by the union of two fields (ex. x and y) and then I will sum the relative sales value. I have to use the script with for example concat funciont or a new variable or what? How can I do? Thanks in advance

DescAsaBreve Old	Sales
x	100
y	200
z	50
u	80

DescAsaBreve New	Sales
x	100
y	200
k	300
z	50
u	80

[#2]

One alternative would be loading them again with the aggregation applied in the script.

such as

Data:

LOAD DescAsaBreve,

     Sales

FROM

[Book2.xlsx]

(ooxml, embedded labels, table is Sheet1);

LOAD 'k' AS DescAsaBreve,

     SUM(Sales) AS Sales

Resident Data

Where DescAsaBreve = 'x' OR DescAsaBreve ='y'

GROUP BY 'k'

[maxgro]

Table:

load * inline [

DescAsaBreve, Sales

x,100

y,200

z,50

u,80

];

Concatenate (Table)

load 'k' as DescAsaBreve,

sum(Sales) as Sales

Resident Table

where Match(DescAsaBreve, 'x', 'y');

[Anonymous]

Thank you very much for your reply .. actually now I just need to create this new dimension k and no set formulas in the script, which are already provided in the tables in the document.

I created a new dimension using the script given below, but the formulas in the document are reset as if did not read the new dimension created (but I see in the list box the new dimension created. Where am I wrong?

Concatenated (Date)
load '99 - AFH 'as DescASABreve
Resident Date
where Match (DescASABreve, '01 - AFH ', '20 - AFH Old', '01 - AFH New ');

[maxgro]

your script seems a little different from my answer

I add to the value k for DescAsaBreve

and the sum(Sales) for field Sales

You only add '99 - AFH 'as DescASABreve' to DescAsaBreve