0 Replies Latest reply: Nov 29, 2017 2:22 AM by Raghav B RSS

    Help in script

    Raghav B

      Hi All,

      below is my pivot data.

      hierarchy is Org name->VP->staff->Manager->student

      pivot.jpg

      In pivot table(qliksense) i want  the name shields to be displayed only once even though he is part of other columns

       

      Below is my load script.

      Table1:

      Orgname,  VP, Student_no

      from ..

      left keep(Table1)

      Table2

      Manager,Student ,Student_no,Staff

       

      from...

      Thanks,

      Raghav