Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

New to Qlik Analytics

If you’re new to Qlik Cloud or Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG

Who Me Too'd this solution

vinieme12
Champion III
Champion III
‎2022-12-08 02:48 AM

In response to prathamesh5017

as below

 

temp:
load * inline [
Student,Subject,Score
A,English,75
A,Maths,55
B,English,80
B,Maths,70
];

load * inline [
Dim,so_Dim
Student,1
Total,2
AverageTotal,3
];

exit Script;

Capture.PNG

 

Row Dimension

=Subject

Column Dimension

=pick(so_Dim,Student,Dim,Dim)

Measure

=pick(so_Dim,Sum(Score),Sum(Score),avg(Score))

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

View solution in original post

1 user say ditto
2,296 Views
Who Me Too'd this solution