topic Re: field selection in QlikView

field selection

ssriramin19 — Wed, 05 Nov 2014 12:36:18 GMT

I have a field which has many values. I have data from the excel with many values for the same field. I need to select all the values which are present in the excel to the report.

I need not do any script changes .I need to know how to achieve through front end selection

Thanks

Sriram

Re: field selection

ssriramin19 — Wed, 05 Nov 2014 12:41:06 GMT

Can anyone please guide me on how to proceed on this

Re: field selection

its_anandrjs — Wed, 05 Nov 2014 12:43:28 GMT

Hi,

May be you can use Concat function.

Regards

Anand

Re: field selection

ssriramin19 — Wed, 05 Nov 2014 12:44:23 GMT

How to go about that?How to use concat function in the front end ?

Re: field selection

Peter_Cammaert — Wed, 05 Nov 2014 12:46:36 GMT

What's the other source of values for this particular field? Is there any characteristic that is linked to this field and that is different depending on the source of field values?

Note that the UI treats all values as one big pile of data. Too late to figure out where individual values came from if you forgot to mark or associate them in the script.

Peter

Re: field selection

ashfaq_haseeb — Wed, 05 Nov 2014 12:48:51 GMT

Hi,

Can you post sample data with expected output?

Regards

ASHFAQ

Re: field selection

Peter_Cammaert — Wed, 05 Nov 2014 12:50:46 GMT

One possible solution may be:

Select all possible values in the excel and copy them to the clipboard. Make sure they're separated by spaces only.

Now in your UI, activate the listbox that shows the field in question, and open the search box (press "space" for example). Paste the list of values in the search box, and press Enter. All values selected...

Re: Re: field selection

ssriramin19 — Wed, 05 Nov 2014 12:55:12 GMT

The attached picture is the list box which contains more than 9000 records. I have data in excel with the same field values .Thenumber of records in the excel is around 536 records. I cannot keep selecting each 500+ records manually .Is there a way out to check if the 536 records are part of 9000 records or not ?

Is there way to achieve in front end ?

Re: field selection

ashfaq_haseeb — Wed, 05 Nov 2014 12:57:39 GMT

Yes look at where Exists function

Regards

ASHFAQ

Re: Re: field selection

ssriramin19 — Wed, 05 Nov 2014 13:25:22 GMT

where exists can be used in list box ?Also I need to use the quotes , ' ' manually for field values .I assume it is time consuming .

Re: Re: field selection

ssriramin19 — Wed, 05 Nov 2014 13:26:35 GMT

Can you still elaboreate further? I am not able to get clear idea on this .Please explain me again

Re: field selection

Peter_Cammaert — Wed, 05 Nov 2014 14:14:54 GMT

What exactly is it that you don't understand?

Re: Re: field selection

ssriramin19 — Mon, 10 Nov 2014 08:34:06 GMT

How to check with exists function? Please elaborate

Re: Re: field selection

ssriramin19 — Mon, 10 Nov 2014 08:35:37 GMT

Is there any function available to check the required data available or not ?I mean to write the function in the list box or in the input box

What should the formula that needs to be applied?

Re: Re: field selection

its_anandrjs — Mon, 10 Nov 2014 08:58:59 GMT

Hi,

Check this simple Where Exists example

New_536_Records:

LOAD ID_Field,'ID Found' as Flag;

LOAD * INLINE [

ID_Field

];

OldRecords_9000_records:

LOAD * INLINE [

ID_Field

] Where Exists(ID_Field);

Here in above only 10,20,30,40,60,50 records loaded between this two tables by using this you can use your Excel list and match it with the existing data.

Regards

Anand

Re: Re: field selection

ssriramin19 — Mon, 10 Nov 2014 11:31:14 GMT

Exists can be used for checking the field values for already loaded function .Am I right ?

The approach what you have suggessted works properly. Thanks very much.