Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Lancelot
Contributor
Contributor

New to Qlik sense : AGGR function

Hi 

I am new to Qlik Sense and do some exercise.

 

Could someone advise how to produce Table1 and Table2?

 

Thank you

 

Lancelot_0-1650441355022.png

 

Labels (3)
1 Solution

Accepted Solutions
vchuprina
Specialist
Specialist

Hi,

Read about Set analysis, resident load, if condition, avg, sum, and count functions and analyze the attached file

Regards,

Vitalii

Press LIKE if the given solution helps to solve the problem.
If it's possible please mark correct answers as "solutions" (you can mark up to 3 "solutions").

View solution in original post

3 Replies
vchuprina
Specialist
Specialist

Hi,

Read about Set analysis, resident load, if condition, avg, sum, and count functions and analyze the attached file

Regards,

Vitalii

Press LIKE if the given solution helps to solve the problem.
If it's possible please mark correct answers as "solutions" (you can mark up to 3 "solutions").
Lancelot
Contributor
Contributor
Author

Hi Vchuprina

Thanks for your quick response - makes perfect sense and worked great.

vchuprina
Specialist
Specialist

Welcome🙂

Press LIKE if the given solution helps to solve the problem.
If it's possible please mark correct answers as "solutions" (you can mark up to 3 "solutions").