Pivot table giving duplicate values

[Anonymous]

Hi All,

below is my pivot data.

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

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

I need help only in front end. not scripting.

Thanks,

Raghav

[Chanty4u]

What is the expression you are using ?

[Anonymous]

no expression used are directly taken from tables

[jonathandienst]

It looks like that value occurs at all those levels. I expect you will need to change the script to handle this case better. Its going to be tricky to handle this entirely in the front end.

[Anonymous]

it was part of an enhancment and cant change the logic in scripting,.

[Anonymous]

Hi Jonathan,

Can you plz let me know what needs to be taken care in load script.

Table1:

Orgname,  VP, Student_no

from ..

left keep(Table1)

Table2

Manager,Student ,Student_no

from...

Thanks

Raghav

[balabhaskarqlik]

Did you resolved the issue, post the solution to help others?