topic Re: IF name1 = name2 in QlikView

IF name1 = name2

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

Hi,

I am trying to use if condition in traffic light gauge expression

*After selecting transaction number, which is link*

=IF( [Owner Name] = [Seller Name], 0,1)

*Both variables are from different tab and excel data. I like to load different excel into different tab for easier fault/error finding.

My traffic light indicator is set as indicate value, segment 1 lower bound 0, segment 2 low bound 0.5.

Please help me

btw, am I able to set the traffic light to a single colour (grey) when nothing is selected?

Message was edited by: Jia Sheng Loh Add In Examples.

Re: IF name1 = name2

Anonymous — Thu, 13 Oct 2016 17:46:16 GMT

Try this

Re: IF name1 = name2

Anonymous — Fri, 14 Oct 2016 00:56:44 GMT

Thanks for the quick reply!

However this I not what I am looking for

I am test if the buyer name is the same as Supplier Name base on supplier code. However there are many supplier name under a same supplier code. Thus, when trying to refer my buyer name to supplier code, it does not light up, On my attachment, with the excel data, Transaction 2 lighted up because there is only one name under that supplier code.

I think is call comparing multiple list to a single list?

Re: IF name1 = name2

nagarjuna_kotha — Fri, 14 Oct 2016 05:16:17 GMT

Could you share sample data ?

-Nagarjun

Re: IF name1 = name2

Anonymous — Fri, 14 Oct 2016 05:46:02 GMT

My post with sample data is currently being moderated. Sry about that.

Re: IF name1 = name2

Anonymous — Tue, 18 Oct 2016 00:31:10 GMT

HI, anyone have a solution?

Re: IF name1 = name2

Anil_Babu_Samineni — Tue, 18 Oct 2016 02:50:11 GMT

Your Expression seems ok to me where do you getting stucked

=Evaluate(Alt(IF([Owner Name] = [Seller Name], 0,1), Null()))

Re: IF name1 = name2

Anonymous — Tue, 18 Oct 2016 03:20:57 GMT

I want to compare a single name (buyer Name) with multiple name (Owner Name) with the same supplier code and my expression is written in the gauge and not back-end script.

For example

OwnerName,Supplier Code

Peter ,1111

James , 1111

BuyerName, Supplier Code

James , 1111

I am stuck at it should return me 1 as BuyerName 'James' match with OwnerName under same supplier code. But my if else statement in the gauge work in the way that it check the first name of OwnerName and return me a 0 instead.

I am unable to use evaluate because my OwnerName is different excel and tab from BuyerName.

Re: IF name1 = name2

Anonymous — Mon, 07 Nov 2016 01:50:04 GMT

HI,

Has anyone able to figure this out? Really appreciate it.