Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Assign new value to a table.

Hi All,

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

NameValue
AAA1
BBB2
CCC3
DDD1
EEE1
FFF4
GGG2
HHH2
III2
JJJ3

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

ValueCost
13
24
32
41
51

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

NameValueCost
AAA13
BBB24
CCC32
DDD13
EEE13
FFF41
GGG24
HHH24
III24
JJJ32

 

How can I do this?.

Best regards,
Juan Muñoz.

Labels (1)
4 Replies
Highlighted
Partner
Partner

hi 

assuming your first table is called Table1 and the second Table2 

than 

left join (Table1) 

load * 

From Table2 

will work 

Highlighted
Contributor III
Contributor III

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

NameValue
AAA1
BBB2
CCC3
DDD1
EEE1
FFF4
GGG2
HHH2
III2
JJJ3

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.

Highlighted
Partner
Partner

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; 

 

Highlighted
Contributor III
Contributor III

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.