topic Re: Filter field based on another field in load in QlikView

Filter field based on another field in load

sibideepak — Thu, 16 Apr 2015 09:10:56 GMT

Hi all,

I want to filter one field based on another field..ex:

Load * inline [

Field1,Field2

A,1

B,1

C,1

D,1

E,2

F,2

G,3

H,3

];

This is just example ..I have huge data set .. What I want to filter is for each Field2 I need First 3 or more Field1 values.

Thu, 16 Apr 2015 09:16:37 GMT

Hi Deepak,

not sure I follow what you are after, by selecting '1' in Field 2 in your example, you will naturally filter to the possible values of Field1 ABC.

So in the load a where clause on field 2 of that value would limit the data to just those 3 values.

Can you explain in more detail what you are looking to do

thanks

Joe

sibideepak — Thu, 16 Apr 2015 09:24:04 GMT

Hi ,

Thanks for response ,

For Each Distinct Field2 I need first 100 records in Field1.

arulsettu — Thu, 16 Apr 2015 09:29:41 GMT

hi try this

first 100 load distinct Field2 ,

Field1

from....