Seperation of data W.R.T 2 columns

[slsaagar]

Hi qlikview developers

please help me out of this..

i have a data that contains order number,material,customer name,group number etc.

i want to Separate the data, if group numbers are not same w.r.t  their order numbers,

For example: attached the data

if order number = 1094334642

                             1094334642

                             1094334642

and  group number =     8

                                       8

                                       1

i want to take the data in which groupnumber=1

how can i do this.....?

thanks in advance

[awhitfield]

Hi Sagar,

I'm not sure exactly what you are after, do you mean when making selections or in a chart etc.

Andy

Have a look at the attached

[slsaagar]

Hi Andrew,

This is Fine for less number of data, i can make selections and export it.

But, i will receive file that contains Lakhs of data(Order numbers) , i want only the

mismatching group number's Data. is it possible to Write the required condition in Script?

Thanks