Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

bsrravikumar
New Contributor III

Help in script

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

Community Browser