Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
chanin7893
Partner - Contributor III
Partner - Contributor III

Ranking of contents

Hello Qlik experts,

I have the following Data

CrossTable(Year,Score,2)

Table:

Load * Inline

[

University, Subject, 2014, 2015, 2016, 2017

A, Sub001, 82, 84, 71, 52

A, Sub002, 52, 61, 69, 96

A, Sub003, 74, 84, 89, 53

B, Sub001, 51, 72, 74, 57

B, Sub002, 83, 88, 78, 90

B, Sub003, 98, 58, 76, 71

C, Sub001, 52, 76, 82, 90

C, Sub002, 50, 86, 65, 84

C, Sub003, 74, 99, 87, 86

D, Sub001, 84, 84, 61, 72

D, Sub002, 92, 81, 99, 94

D, Sub003, 51, 71, 71, 96

E, Sub001, 62, 73, 60, 92

E, Sub002, 96, 51, 81, 55

E, Sub003, 55, 75, 81, 72

F, Sub001, 95, 73, 76, 83

F, Sub002, 96, 62, 77, 71

F, Sub003, 93, 92, 74, 60

] ;

I require the following output

IMG-20170822-WA0003.jpg

8 Replies
agigliotti
Partner - Champion
Partner - Champion

to ignore all user selections use {1} in set analysis.

chanin7893
Partner - Contributor III
Partner - Contributor III
Author

I have done that, but the rank must adjust according to subjects as well. That's actually my main issue. If I use {1} in the expression, its doesn't sort the rank as per SUBJECTS.

agigliotti
Partner - Champion
Partner - Champion

to ignore all selections except for "subject" field you have to use this below:

{1< subject ::$subject >}

i hope it helps.

chanin7893
Partner - Contributor III
Partner - Contributor III
Author

Rank(Sum({1<Subject::$Subject >}Score)) * Avg(1)

This is the expression I have applied in the Measure.

Its showing me error in set modifier expression

agigliotti
Partner - Champion
Partner - Champion

i'm sorry try below:

Rank(Sum({1<Subject=::$Subject >}Score)) * Avg(1)

chanin7893
Partner - Contributor III
Partner - Contributor III
Author

When I'm entering this expression all the Ranks are being equated to 3.5 irrespective of subject or score

MK_QSL
MVP
MVP

agigliotti
Partner - Champion
Partner - Champion

could you please post a sample qvf ?

at this point it needed to understand what you are trying to achieve.