Skip to main content
Announcements
Sept. 27, 10AM ET Do more with Qlik, Insight Advisor – our intelligent AI-assistant in Qlik Sense: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
vvvvvvvvvv
Creator
Creator

How to get the average of min record by id

vvvvvvvvvv_0-1597218184464.png

How to calculate the average grade of student when records for STDT_ID 4 are duplicated in qliksense measure?

I know it can calculate by average the min record by ID. But don't know how to implement in QS measuer.

 

Labels (4)
6 Replies
rockabs
Contributor III
Contributor III

Perhaps this

Avg({<[STDT ID]={"=Count([STDT ID])>1"}>} [STDT ID])

vvvvvvvvvv
Creator
Creator
Author

I want to get the average grade??

vvvvvvvvvv
Creator
Creator
Author

what if I also want the year equal to some specific year?

Anil_Babu_Samineni

Perhaps this

Avg({<[STDT ID]={"=Count([STDT ID])>1"}, Year={2019}>} Grade)

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
vvvvvvvvvv
Creator
Creator
Author

It only work for there are multiple records with same id, cannot include the single record

Anil_Babu_Samineni

From Given Snapshot, What is the outcome you are looking?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)