listboxes and calculation

[MT4T]

Hi. i have inphinity forms table called "SKILLS".

I takes from this all column names with listboxes loop (working well).

I need to do visualization (table). Where first column will show "COLUMN_NAME" from listboxes

and second column will be calculated AVG value from table "SKILLS" (source for listboxes).

Measure should find column in "SKILLS" table according COLUMN_NAME from list boxes.

Next step will be add employee and department according to "ID" column in table "SKILLS".

Idk if this approach is the best solution maybe crosstable is better but I am wondering if such calculation is possible.

Below my data model:

Thanks in advance.

[Chanty4u]

Try this 

=Avg({<COLUMN_NAME=>} Aggr(YourExpressionHere, COLUMN_NAME, ID, Employee, Department))

[MT4T]

Hi, thank you for response. It seems to be good direction.

I have modified expression (ID means ID of Employee so this is the same).

There is one more thing which need to be adjusted.

I have no clue how i can replace "AVG(vEnglish) with values from "COLUMN_NAME". 

Actually each row should contain different reference. Which should be read form "COLUMN_NAME"

for example:

row 1 - fAccess

row 2 - fCalendar

row 3 - fData modeling

row 4 - fEnglish

....

[MT4T]

Hi, thank you for response. It seems to be good direction.

I have modified expression (ID means ID of Employee so this is the same).

There is one more thing which need to be adjusted.

I have no clue how i can replace "AVG(vEnglish) with values from "COLUMN_NAME". 

Actually each row should contain different reference. Which should be read form "COLUMN_NAME"

for example:

row 1 - fAccess

row 2 - fCalendar

row 3 - fData modeling

row 4 - fEnglish

....

[marcus_sommer · Accepted solution]

I suggest to change the data-model because it's very cumbersome to handle crosstable-structures and much easier with an appropriate transforming: The Crosstable Load - Qlik Community - 1468083