Assign new value to a table.

[JuanMu]

Hi All,

I'm not sure if is possible to do this, I have a table with 10 registers:

Name	Value
AAA	1
BBB	2
CCC	3
DDD	1
EEE	1
FFF	4
GGG	2
HHH	2
III	2
JJJ	3

I can calculate how many registers are repeated, this new value it is a cost:

Value	Cost
1	3
2	4
3	2
4	1
5	1

Now I would need to assign the cost to each register:

Name	Value	Cost
AAA	1	3
BBB	2	4
CCC	3	2
DDD	1	3
EEE	1	3
FFF	4	1
GGG	2	4
HHH	2	4
III	2	4
JJJ	3	2

How can I do this?.

Best regards,
Juan Muñoz.

[lironbaram]

hi 

assuming your first table is called Table1 and the second Table2 

than 

left join (Table1) 

load * 

From Table2 

will work 

[JuanMu]

Hi lironbaram,
I have only one table, all the data are generated from a unic table:

Name	Value
AAA	1
BBB	2
CCC	3
DDD	1
EEE	1
FFF	4
GGG	2
HHH	2
III	2
JJJ	3

Could you please explain more in detail how I can set this, I have very bit experience with Qlik Sense.

Best regards,
Juan Muñoz.

[lironbaram]

Hi 

Ok so it's be like this 

Data:
load Name,
     Value 
From Source ;
left join (Data)
load Value,
     count(Name) as Cost
resident Data
Group by Value; 

[JuanMu]

Hi

It works properly, but I have a problem, as the configuration is did in the script, the data are statics.

For instance: in the table I have 3 "Name" with "Value"=1 the Cost for the "Name (AAA,DDD,,EEE)" it is 3 correct, if I show these 3 "Name" in a graphic the cost it is 3, but if with a filter I select the "Name" AAA and EEE the cost must be 2 and not 3.
Is possible to generate the same behavior in a graphic function?.

Best regards,

Juan Muñoz.