Using two Arguments in Set Analysis

Wed, 16 Mar 2011 15:56:52 GMT

Hi All

=Aggr(Only({$<[Claimant State]={'Closed'}[Is Latest Ref Seq]=>}[Claim Transaction Done Date]),[Claimant Number])

This is my Formula which works fine however the formula only shows details that I need when Claimant State = Closed I also need it to show the details when claimant state = Reclosed. I tried The following

=Aggr(Only({$<[Claimant State]={'Closed'},[Claimant State]={'ReClosed'}, [Is Latest Ref Seq]=>}[Claim Transaction Done Date]),[Claimant Number])

This doesn't quite work as I believe what I have done is told it to only show what I want if = Closed and Reclosed were I need it to be an OR.

Hope this makes sense

Thanks for any response in advance

Using two Arguments in Set Analysis

Wed, 16 Mar 2011 16:12:21 GMT

Try:

[Claimant State]={'Closed','ReClosed'}

Regards,

Gordon

Using two Arguments in Set Analysis

Wed, 16 Mar 2011 16:20:17 GMT

That is Perfect thanks.

topic Using two Arguments in Set Analysis in QlikView

Using two Arguments in Set Analysis

Using two Arguments in Set Analysis

Using two Arguments in Set Analysis