topic Re: If Else Condition Fails in QlikView

If Else Condition Fails

rajni_batra — Mon, 14 Jan 2013 14:48:55 GMT

Hello Guys,

I have a scenario like i Have 2 Fields A and B

if(A<>B, 'Yes','No') but for some IDs both conditions are true but i want to display it as YES only if its falling in No also.

Re: If Else Condition Fails

Or — Mon, 14 Jan 2013 14:54:23 GMT

I don't follow. Either A <> B, or it isn't. How can both conditions be true? Perhaps you could post some sample data?

Re: If Else Condition Fails

rajni_batra — Mon, 14 Jan 2013 16:51:20 GMT

Here against One ID there 3 FBC's in Web but 1 FBC in NAV. i have used expression

Booking ID	Web FBC	NAV FBC	=1
			1
NN251683034998	EAP30	EAP30	1
NN251683034998	LE3M	EAP30	1
NN251683034998	SAP14	EAP30	1
NN251683034998	WE4M	EAP30	1

=if([Nav FBC]<>[Web FBC],'FBC','NON FBC')

and OutPut is like below:

Booking ID	Web FBC	NAV FBC	=if([NAV ]<>[Web FBC] and Flag='Both' and Status='E','FBC','NON FBC')	=1
				1
NN251683034998	EAP30	EAP30	NON FBC	1
NN251683034998	LE3M	EAP30	FBC	1
NN251683034998	SAP14	EAP30	FBC	1
NN251683034998	WE4M	EAP30	FBC	1

Hope this will clear my problem

Regards,

rajni

Re: If Else Condition Fails

christian77 — Mon, 14 Jan 2013 17:08:52 GMT

Hi:

You may have double values in some cases. That means, for a value of A, you have 2 values on B, and one accomplishes the equality and the other one does not. The result is null.

Check that out.

Re: If Else Condition Fails

rajni_batra — Tue, 15 Jan 2013 05:46:57 GMT

Sorry But I couldn't Get you..

Re: If Else Condition Fails

Tue, 15 Jan 2013 06:07:54 GMT

Hi Rajini,

post sample file with some data.. so, that it will be clear

Re: If Else Condition Fails

Or — Tue, 15 Jan 2013 12:26:01 GMT

I'm still not really clear - what was the output you expected to see? What is incorrect with the output you posted?

If the idea is to have one line for each booking ID, and "True" if at least one case of Web FBC = NAV FBC exists, you could probably use something like:

If(sum(if([Web FBC] = [NAV FBC],1)>0,'True','False').

Which is to say - first, count the number of cases where Web = NAV and then if that number is greater than 0, show true. This should work in a chart where Booking ID is the dimension and this is an expression. If you need to use it in a dimension, you'd have to use aggr().