Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
abhaysingh
Specialist II
Specialist II

logic help11

bwartkey_bwart_xblnr101_xblnr101_Keyqtyxblnr
641641|1001101|1001 101001
641641|1002101|1002 201002
101101|1005 101|1005101005
101101|1002 101|1002201002
541541|1003 301003
542542|1004 401004
543543|1005 501005

in this with field 101_key, can i compare 101_xblnr, when they will not equal it will give me, as output 101|1001 = 10

8 Replies
swuehl
MVP
MVP

Sorry, I don't understand that. Could you go through you example line by line and describe what's your input and how you derive your expected results?

Gysbert_Wassenaar

LOAD

     bwart,

     key_bwart_xblnr,

     101_xblnr,

     101_Key,

     qty,

     xblnr,

     if(101_Key <> key_bwart_xblnr, 101_xblnr & '=' & qty) as NewField

FROM

     ...

     ;


talk is cheap, supply exceeds demand
abhaysingh
Specialist II
Specialist II
Author

HI swuehl,

See i have two field 101_xblnr and 101_Key, these are the fields i have created

will following conditions

if(bwart = 641, '101'&'|'&xblnr) as 101_xblnr

and

if( bwart = '101', bwart&'|'&xblnr ) as [101_Key],

now i have two different field in which i want to do the comparison,

you can see the value is coming against , bwart value, 641 and 101... in this i made a change in 641 with 101.

so the final output will come in the form of 101.

now as i asked earlier, after comparing value of two created fields, i.e. 101_xblnr and [101_Key],

in both the fields i have some common value and non common value, non common values are

101|1001 in field 101_xblnr  , in this bwart is 641


and 101|1005 in field [101_Key] , in this bwart is 101.

now final output required when bwart is 641 and non common which is 10 in this scenario.

hope m clear.

thanks in advance

swuehl
MVP
MVP

Well ... no.

But I assume / hope Gysbert got a better understanding of what you are trying to do.

Anonymous
Not applicable

Create a Flag at script, sth like?

If(101_key=101_xblnr, 'Equal','Not equal') as Flag

And then use Flag value to differentiate..

Anonymous
Not applicable

=10 is what, Qty??

abhaysingh
Specialist II
Specialist II
Author

yes

abhaysingh
Specialist II
Specialist II
Author

can u build the sample for me?