How to use a calculated field in another table?

[Anonymous]

Hi All,

I have the following input table: (Attached picture)

Now, i have created a calculated field in Qlik Sense to give score i.e. if the activity is indoor -(Cards, Chess & Foosball) give score 2 else give 3. Now i want to use this calculated field to roll up at a student level.

How can i use the field (score) that i created to calculate score at a student level

please refer the attached picture for output

[Anonymous]

[christophebrault]

Hi,

You simply have to create your output tab le from the previous one and sum the score with Group By

Something like :

Output:

LOAD Student,

           Sum(Score) as Score

Resident Input

Group By Student;

Drop Table Input;

[shiveshsingh]

Take dimension : Student

and Measure : sum(Score)

[Anonymous]

Thanks Christophe

how can i see the table name ? . The "Input" table I mentioned is actually a table i created in the view from an excel file.

[christophebrault]

You have to load this table from the script editor

Create a connexion to your folder, load the table, rename, etc.