Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
slsaagar
Contributor II
Contributor II

Seperation of data W.R.T 2 columns

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

2 Replies
awhitfield
Partner - Champion
Partner - Champion

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
Contributor II
Contributor II
Author

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