topic Re: logic help11 in QlikView

logic help11

abhaysingh — Wed, 25 Nov 2020 16:16:04 GMT

bwart	key_bwart_xblnr	101_xblnr	101_Key	qty	xblnr
641	641\|1001	101\|1001		10	1001
641	641\|1002	101\|1002		20	1002
101	101\|1005		101\|1005	10	1005
101	101\|1002		101\|1002	20	1002
541	541\|1003			30	1003
542	542\|1004			40	1004
543	543\|1005			50	1005

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

Re: logic help11

swuehl — Wed, 13 Apr 2016 09:01:48 GMT

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?

Re: logic help11

Gysbert_Wassenaar — Wed, 13 Apr 2016 09:19:12 GMT

LOAD

bwart,

key_bwart_xblnr,

101_xblnr,

101_Key,

qty,

xblnr,

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

FROM

...

;

Re: logic help11

abhaysingh — Wed, 13 Apr 2016 09:25:44 GMT

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

Re: logic help11

swuehl — Wed, 13 Apr 2016 09:30:11 GMT

Well ... no.

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

Re: logic help11

Anonymous — Wed, 13 Apr 2016 09:40:04 GMT

Create a Flag at script, sth like?

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

And then use Flag value to differentiate..

Re: logic help11

Anonymous — Wed, 13 Apr 2016 09:41:01 GMT

=10 is what, Qty??

Re: logic help11

abhaysingh — Wed, 13 Apr 2016 10:11:52 GMT

yes

Re: logic help11

abhaysingh — Wed, 13 Apr 2016 10:12:40 GMT

can u build the sample for me?