topic Creating a Master Client List in QlikView

Creating a Master Client List

Mon, 16 Dec 2013 16:00:05 GMT

Very new to QlikView and need help creating a master client list to help with further analysis.

I am working with one simple (but large) qvd file with 28 columns. I have a listing of every client that has visited our facility from 2010 until present. Each row is a unique encounter and contains a column to identify Client_Name, Client_ID, Visit_Date, Visit_Time (as they may visit more than once per day).

This, however, means that a client's name and ID can repeat numerous times. I would like to create a client list based on this information, but have no clue how to or what the necesssary terms are to search for help.

The idea is that even though a client's name and ID appear more than once, the master list will only list that cilent once. Can this be done? If so, how and then, how do I reference this list for all my other calculations?

Thank you in advance from a very new user.

Re: Creating a Master Client List

Gysbert_Wassenaar — Mon, 16 Dec 2013 16:07:49 GMT

If you want a unique list of clients you can simple add the clients name field to a listbox. A listbox will show only unique values. A table box object with only the client name field does the same.

Re: Creating a Master Client List

Mon, 16 Dec 2013 16:24:02 GMT

That works, very simple . Thank you.

I've also been working on another problem you may have insights to:

How do I filter contents of a table and rank them at the same time?

http://community.qlik.com/thread/101682