Discussion board where members can learn more about Qlik Sense App Development and Usage.
My Input table as below with Student with filter: In filter there are below students and data accordingly
Below are student names which are in filter on the same sheet and table
My required output as below(Please help me to achieve this output using qliksense):
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, CyclingFROM [..\..\..\Downloads\StudentData.xlsx] (ooxml, embedded labels, table is Blad1, filters(Transpose(),Replace(1, top, StrCnd(null))));