topic Re: If statement to isolate a match in QlikView

If statement to isolate a match

Wed, 08 Apr 2015 07:13:45 GMT

I have two document with a id say Car Reg Number, I've tried different statements but can't get i right. How can i isolate all reg numbers that occurs in both documents?

So if a reg number is in sheet1 and sheet 2 isolate this number,

any tips?

thx

Theo

Re: If statement to isolate a match

Anonymous — Wed, 08 Apr 2015 15:16:08 GMT

not sure what you exactly want

using exsits could get you those datasets whichexists in both dos

Doc1:

load *

resident File1

Doc2:

noconcatenate load *

resident File2

where exists (Car Reg Number)

for correct syntax please check help or provide an example app

Re: If statement to isolate a match

Thu, 09 Apr 2015 07:29:58 GMT

Im new to qlikview it your tip pointed me to the answer and solved my problem. Thank you..

//Theo