topic Condition for the status in QlikView

Condition for the status

vardhancse — Mon, 07 Jul 2014 05:24:45 GMT

Hi,

Have a requirement is that,

I am trying to create one calculated dimension based on 3 fields.

Fields:

now the condition is that if the count(1=2=3),'Match','Not Match')

if(1= 2 & 2=3,'Matched','Not Matched') as Count_Status

tresB — Mon, 07 Jul 2014 05:26:58 GMT

if(1= 2 AND 2=3,'Matched','Not Matched') as Count_Status

Assuming 1,2,3 are field names.

er_mohit — Mon, 07 Jul 2014 05:41:44 GMT

try this on front end side

aggr(if(1= 2 AND 2=3,'Matched','Not Matched'),1,2,3)

check on suppress null value