Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

sahibakaur
New Contributor II

How to use a calculated field in another table?

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

5 Replies
sahibakaur
New Contributor II

Re: How to use a calculated field in another table?

INPUT TABLE.jpgOUTPUT TABLE.jpg

christophebraul
Contributor III

Re: How to use a calculated field in another table?

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
Honored Contributor

Re: How to use a calculated field in another table?

Take dimension : Student

and Measure : sum(Score)

sahibakaur
New Contributor II

Re: How to use a calculated field in another table?

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.

christophebraul
Contributor III

Re: How to use a calculated field in another table?

You have to load this table from the script editor

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

Community Browser