topic Re: Seperation of data W.R.T 2 columns in QlikView

Seperation of data W.R.T 2 columns

slsaagar — Thu, 21 May 2015 12:06:25 GMT

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

and group number = 8

i want to take the data in which groupnumber=1

how can i do this.....?

thanks in advance

awhitfield — Thu, 21 May 2015 13:43:41 GMT

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 — Fri, 22 May 2015 09:33:10 GMT

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