topic Re: Condition in QlikView

Condition

vardhancse — Mon, 14 Jul 2014 07:32:22 GMT

Hi,

Have a requirement is that.

creating one field based on condition:

if(A_Row_Count = B_Row_Count AND A_Row_Count = C_Count AND C_Count = B_Row_Count,'Matched','Not Matched') as Count_Status

But my requirement is that:

if field C_Count have data above condition will work out and show the count_status as Match/Mot Match

if field C_Count have no data, then it should check only field A_Row_Count & B_Row_Count and show the status as Match/Not Match

Re: Condition

alexandros17 — Mon, 14 Jul 2014 07:36:26 GMT

Try this

If(Sum(C_Count)>0,

if(A_Row_Count = B_Row_Count AND A_Row_Count = C_Count AND C_Count = B_Row_Count,'Matched','Not Matched'),

if(A_Row_Count = B_Row_Count ,'Matched','Not Matched')

) as Count_Status

let me know ...

Re: Condition

sasikanth — Mon, 14 Jul 2014 07:37:40 GMT

Try some thing like below

if(A_Row_Count = B_Row_Count AND if(not is null(C_Count), A_Row_Count = C_Count AND C_Count = B_Row_Count),'Matched','Not Matched') as Count_Status

Re: Condition

Anonymous — Mon, 14 Jul 2014 19:22:03 GMT

you can check length of C_COUNT or you can use isnull function and based on that modify your if statements. It will have basically 2 ifstatements

if( len(C_COUNT)=0,

<first if statement)>,

<second if statements>)