topic Re: Pivot table giving duplicate values in QlikView

Pivot table giving duplicate values

Anonymous — Thu, 09 Nov 2017 07:11:02 GMT

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

Re: Pivot table giving duplicate values

Chanty4u — Thu, 09 Nov 2017 07:19:43 GMT

What is the expression you are using ?

Re: Pivot table giving duplicate values

Anonymous — Thu, 09 Nov 2017 07:56:08 GMT

no expression used are directly taken from tables

Re: Pivot table giving duplicate values

jonathandienst — Thu, 09 Nov 2017 08:01:20 GMT

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.

Re: Pivot table giving duplicate values

Anonymous — Thu, 09 Nov 2017 08:14:02 GMT

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

Re: Pivot table giving duplicate values

Anonymous — Wed, 29 Nov 2017 06:24:27 GMT

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

Re: Pivot table giving duplicate values

BalaBhaskar_Qlik — Mon, 06 Aug 2018 12:50:53 GMT

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