Solved: Re: field selection - Qlik Community

ssriramin19 · ‎2014-11-05

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

its_anandrjs · ‎2014-11-10

Hi,

Check this simple Where Exists example

New_536_Records:

LOAD ID_Field,'ID Found' as Flag;

LOAD * INLINE [

ID_Field

10

20

30

40

60

50

];

OldRecords_9000_records:

LOAD * INLINE [

ID_Field

10

20

30

40

2

50

] 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

View solution in original post

ssriramin19 · ‎2014-11-05

Can anyone please guide me on how to proceed on this

its_anandrjs · ‎2014-11-05

Hi,

May be you can use Concat function.

Regards

Anand

ssriramin19 · ‎2014-11-05

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

Peter_Cammaert · ‎2014-11-05

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

ashfaq_haseeb · ‎2014-11-05

Hi,

Can you post sample data with expected output?

Regards

ASHFAQ

Peter_Cammaert · ‎2014-11-05

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...

ssriramin19 · ‎2014-11-05

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 ?

ashfaq_haseeb · ‎2014-11-05

Yes look at where Exists function

Regards

ASHFAQ

ssriramin19 · ‎2014-11-05

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 .