topic Re: Filtering and extracting records in QlikView

Filtering and extracting records

Anonymous — Mon, 11 May 2015 12:44:07 GMT

Hi,

I have imported a huge file of the entire organizational employee data, now I wish to make it public to my team and utilize it in a user friendly way, one of the ways to do that is to filter and extract multiple employee numbers they are interested in.

I know filtering works but it works on just 1 record at a time, so I am looking at a way for the end user to select and extract multiple data at one time. So let's say I wanna extract employee number 1,2,3,4,20,30,40 from the employee list, how can I do that

Thanks

Sunny

Re: Filtering and extracting records

Anonymous — Mon, 11 May 2015 12:49:16 GMT

Sunny, you assumption "filtering works but it works on just 1 record at a time" is in fact incorrect. If the selections are made, for example, in a list box, you can press and hold the CTRL key and select as many records as you wish.

Or, you can create an input box where you enter the desired values, and apply the filter by a button click.

Re: Filtering and extracting records

Anonymous — Mon, 11 May 2015 13:08:56 GMT

Thanks for the reply @Michael Solomovich

I see what you are saying, the problem with the CTRL Key method is that if a user has to select 100 or 200 records, it becomes very difficult to find and select.

Let me know of a more user friendly way please

Thanks

Re: Filtering and extracting records

sujeetsingh — Mon, 11 May 2015 13:11:27 GMT

You can have combination of selection to filter such huge data. For example some group , Year, Zone City

Re: Filtering and extracting records

Anonymous — Mon, 11 May 2015 13:27:58 GMT

Yes, more often than not, when you select multiple records, you select the records that have some attribute in common, e.g. a geography, or a specialty.

If you have to select records that are mostly random, it will be difficult to select using CTRL. A hint - you don't have to keep it pressed all the time. After making a few selections, you can release it. After that you can just type another value, and when you see it in the list box - press CTRL and click on it. It will be added without clearing the previously selected values.

Again, think of a variable and a button with select or toggle select action.

Re: Filtering and extracting records

Ralf-Narfeldt — Mon, 11 May 2015 13:33:41 GMT

You can also select multiple values by holding down the mouse key and dragging the cursor, handy for selecting a range.

If there is something common with the selections the user usually wants to make, you can create fields that provide quick filters for that.

Re: Filtering and extracting records

jpenuliar — Mon, 11 May 2015 13:39:51 GMT

If you have more than 100 items, You can probably have a text file drop into a folder to get retrieved or like an upload file mechanism to load to your QV file

Re: Filtering and extracting records

Anonymous — Tue, 12 May 2015 12:52:19 GMT

Yes @Jonathan Penuliar, I was hoping to do something like this, can u pls tell me how can I do that?

Re: Filtering and extracting records

jpenuliar — Tue, 12 May 2015 13:04:21 GMT

I imagine, if I am your user, I'd be having a had time making the 100 selections.

Even if you have a list box, I'd grow tired of clicking selections.

I don't think this is the best course of user interactivity.

as the community have pointed out, if your selections (100-200, regardless) have a common attributes like Department, Age range, or User Type it is best to make selections/filter this way.

If you still want to make 100+ selections in one go, look into using Input box" object to fetch your selection list, as msolomov already suggested.

Re: Filtering and extracting records

petter — Tue, 12 May 2015 13:11:59 GMT

Actually the simplest most flexible and fastest way of doing it is using the built-in search facility that QlikView offers. Simply teach your users how to do search on multiple numbers and then they can even save those searches as bookmarks which they could reuse.

For example if you have a list box with Employee Number then by clicking on the search icon or just clicking on the title of the list box ... start typing:

(1001|1004|1099|1499)

Then you will get select all the four employees with the corresponding numbers... To see all the employee-list while you search for new ones you could include a wildcard and when you are done you can remove it before you press enter.

(*|1001|1006|1534) and before you press enter you can remove the first *|

It is easy to create a bookmark and that will be based on the search you made...