Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
My Input table as below with Student with filter: In filter there are below students and data accordingly
Input:
Student | John | ||||||||
Week | Jan-06 | Jan-13 | Jan-20 | Jan-27 | Feb-03 | Feb-10 | Feb-17 | Feb-24 | Mar-03 |
Activities | |||||||||
Sports | 11 | 12 | 32 | 32 | 23 | 43 | 33 | 24 | 35 |
Gym | 12 | 11 | 31 | 34 | 25 | 40 | 34 | 25 | 34 |
Swimming | 13 | 10 | 30 | 36 | 27 | 37 | 35 | 26 | 33 |
Blogging | 14 | 9 | 29 | 38 | 29 | 34 | 36 | 27 | 32 |
Cycling | 15 | 8 | 28 | 40 | 31 | 31 | 37 | 28 | 31 |
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):
Week | Student | Sports | Gym | Swimming | Blogging | Cycling |
Jan-06 | John | 11 | 12 | 13 | 14 | 15 |
Jan-13 | John | 12 | 11 | 10 | 9 | 8 |
Jan-20 | John | 32 | 31 | 30 | 29 | 28 |
Jan-27 | John | 32 | 34 | 36 | 38 | 40 |
Feb-03 | John | 23 | 25 | 27 | 29 | 31 |
Feb-10 | John | 43 | 40 | 37 | 34 | 31 |
Feb-17 | John | 33 | 34 | 35 | 36 | 37 |
Feb-24 | John | 24 | 25 | 26 | 27 | 28 |
Mar-03 | John | 35 | 34 | 33 | 32 | 31 |
Jan-06 | Alice | Accordingly | Accordingly | Accordingly | Accordingly | Accordingly |
Jan-13 | Alice | Accordingly | Accordingly | Accordingly | Accordingly | Accordingly |
Jan-20 | Alice | Accordingly | Accordingly | Accordingly | Accordingly | Accordingly |
Jan-27 | Alice | Accordingly | Accordingly | Accordingly | Accordingly | Accordingly |
Feb-03 | Alice | Accordingly | Accordingly | Accordingly | Accordingly | Accordingly |
Feb-10 | Alice | Accordingly | Accordingly | Accordingly | Accordingly | Accordingly |
Feb-17 | Alice | Accordingly | Accordingly | Accordingly | Accordingly | Accordingly |
Feb-24 | Alice | Accordingly | Accordingly | Accordingly | Accordingly | Accordingly |
Mar-03 | Alice | Accordingly | Accordingly | Accordingly | Accordingly | Accordingly |
and so on...
I am stuck with this for last 2 days. Your help will be much appreciated
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))
));