Cross table Along With Filter

Ron1 — Tue, 07 Jan 2020 13:32:12 GMT

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

Re: Cross table Along With Filter

Vegar — Tue, 07 Jan 2020 14:15:52 GMT

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))
));

topic Cross table Along With Filter in App Development

Cross table Along With Filter

Re: Cross table Along With Filter