topic Re: Showing all replica fields in QlikView

Showing all replica fields

khaycock — Wed, 25 Nov 2020 16:16:04 GMT

I have an Excel flat file that is showing 18 lines for new hires like this:

In my pivot table on the dashboard I want to display all 18 of these lines, but it is only showing the line once because it is the same. When a count is added you can see its 18 but I actually want it shown 18 times in the table instead?

Any ideas?

Re: Showing all replica fields

sunny_talwar — Thu, 22 Jun 2017 13:24:41 GMT

May be add a unique identifier while loading your data

LOAD RowNo() as UniqueIdentifier,

Field1,

Field2,

Field3,

....

FROM ....;

and now add UniqueIdentifer as one of the pivot table dimension