Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
hi
assuming your first table is called Table1 and the second Table2
than
left join (Table1)
load *
From Table2
will work
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.
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;
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.