Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

chanin7893
New 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
Honored Contributor II

Re: Ranking of contents

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

chanin7893
New Contributor III

Re: Ranking of contents

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

Re: Ranking of contents

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

{1< subject ::$subject >}

i hope it helps.

chanin7893
New Contributor III

Re: Ranking of contents

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

Re: Ranking of contents

i'm sorry try below:

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

chanin7893
New Contributor III

Re: Ranking of contents

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

Re: Ranking of contents

agigliotti
Honored Contributor II

Re: Ranking of contents

could you please post a sample qvf ?

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