Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

khaycock
Contributor

Showing all replica fields

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

new hire 1.PNG

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?

newhire2.PNG

Any ideas?                        

Tags (1)
1 Reply

Re: Showing all replica fields

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