Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
to ignore all user selections use {1} in set analysis.
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.
to ignore all selections except for "subject" field you have to use this below:
{1< subject ::$subject >}
i hope it helps.
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
i'm sorry try below:
Rank(Sum({1<Subject=::$Subject >}Score)) * Avg(1)
When I'm entering this expression all the Ranks are being equated to 3.5 irrespective of subject or score
From where you got this question???
could you please post a sample qvf ?
at this point it needed to understand what you are trying to achieve.