Discussion Board for collaboration related to QlikView App Development.
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
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
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