Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Ron1
Partner
Partner

Cross table Along With Filter

My Input table as below with Student with filter: In filter there are below students and data accordingly

Input:

StudentJohn        
          
WeekJan-06Jan-13Jan-20Jan-27Feb-03Feb-10Feb-17Feb-24Mar-03
Activities         
Sports111232322343332435
Gym121131342540342534
Swimming131030362737352633
Blogging14929382934362732
Cycling15828403131372831

 

Below are student names which are in filter on the same sheet and table

Student
John
Alice
Emma
Towney
Zakir
Himanshu

 

My required output as below(Please help me to achieve this output using qliksense):

WeekStudentSportsGymSwimmingBloggingCycling
Jan-06John1112131415
Jan-13John12111098
Jan-20John3231302928
Jan-27John3234363840
Feb-03John2325272931
Feb-10John4340373431
Feb-17John3334353637
Feb-24John2425262728
Mar-03John3534333231
Jan-06AliceAccordinglyAccordinglyAccordinglyAccordinglyAccordingly
Jan-13AliceAccordinglyAccordinglyAccordinglyAccordinglyAccordingly
Jan-20AliceAccordinglyAccordinglyAccordinglyAccordinglyAccordingly
Jan-27AliceAccordinglyAccordinglyAccordinglyAccordinglyAccordingly
Feb-03AliceAccordinglyAccordinglyAccordinglyAccordinglyAccordingly
Feb-10AliceAccordinglyAccordinglyAccordinglyAccordinglyAccordingly
Feb-17AliceAccordinglyAccordinglyAccordinglyAccordinglyAccordingly
Feb-24AliceAccordinglyAccordinglyAccordinglyAccordinglyAccordingly
Mar-03AliceAccordinglyAccordinglyAccordinglyAccordinglyAccordingly

and so on...

I am stuck with this for last 2 days. Your help will be much appreciated

 

1 Reply
Vegar
Partner
Partner

This might help you started.

LOAD
  Student,
  Week,
  Sports,
  Gym,
  Swimming,
  Blogging,
  Cycling
FROM
  [..\..\..\Downloads\StudentData.xlsx]
  (ooxml, embedded labels, table is Blad1, filters(
Transpose(),
Replace(1, top, StrCnd(null))
));

 

Plees ekskuse my Swenglish and or Norweglish spelling misstakes