syntax FOR SUBSET

[qolkaram]

Hi All

Can any one help me to fix syntax for below selection :

SELECT SUM ( OUTAGE_DURATION_MINUTE) 

WHERE  CAT={'Technical','NoneTech'}  AND  MAIN_CAUSE <> 'CR' 

here is my exercise but it is not working :

Sum({<CAT={'Technical','NoneTech'} , not match(MAIN_CAUSE, 'CR')  >}OUTAGE_DURATION_MINUTE)

thanks

Nassim

[Anil_Babu_Samineni]

May be this?

Sum({<CAT={'Technical','NoneTech'} , MAIN_CAUSE -= {'CR'}  >} OUTAGE_DURATION_MINUTE)

[qolkaram]

thanks for your reply but still there is an error

[Anil_Babu_Samineni]

Can you show image

[qolkaram]

[Anil_Babu_Samineni · Accepted solution]

This should work, May be this

Sum({<CAT={'Technical','NoneTech'} , MAIN_CAUSE =- {'CR'}  >} OUTAGE_DURATION_MINUTE)

Or

Sum({<CAT={'Technical','NoneTech'} , MAIN_CAUSE = {'*'}-{'CR'}  >} OUTAGE_DURATION_MINUTE)

If not, Please post sample application

[tresesco]

This is not an error but a warning. Ignore it. This improper warning with '-' (negation) sign in set analysis is known. It works fine with that warning.

[qolkaram]

thanks ,it is working

[Anil_Babu_Samineni]

I am assuming, could be Version issue. Please correct me if i am wrong. I am working on QV 12

[tresesco]

Yes, perhaps this has just got corrected in QV12 and onward.