Qlik Community

Qlik Sense Cloud Discussions

chrisellis
Contributor

Transpose in Table

Is it possible to filter the same column twice in one table.

     Before Table

PupilGradeProgress Update
Pupil A2SY7-Pu3
Pupil A1EY7-Pu2

After Table      

PupilGradeProgress UpdateGradeProgress Update
Pupil A2SY7-Pu31EY7-Pu2
2 Replies
philip_doyne
Contributor II

Re: Transpose in Table

Christopher, research Generic Load in Qlik Community or Qlik Help – it might be what you are after. Philip

Philip Doyne, Technical Director

QlickiT, Century Business Centre, Manvers, Rotherham, South Yorkshire, S63 5DA

Email : philip.doyne@qlickit.co.uk<mailtoSmiley Tonguehilip.doyne@qlickit.co.uk> | Office : 01709 300230 | Mobile : 07930 401440 | Web : www.qlickit.co.uk<http://www.qlickit.co.uk/>

pover
Honored Contributor

Re: Transpose in Table

Hi Christopher,

If you select Pupil A in a Qlik Sense filter both rows will be returned.  There is no need to change the table to the After Table format unless you want to distinguish the different grades in an accumulating snapshot.  I found this post that may help you understand if what you are looking for is an accumulating snapshot Diethard Steiner On Business Intelligence

Karl

Community Browser