topic Re: syntax FOR SUBSET in QlikView

syntax FOR SUBSET

qolkaram — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: syntax FOR SUBSET

Anil_Babu_Samineni — Sun, 23 Apr 2017 06:49:25 GMT

May be this?

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

Re: syntax FOR SUBSET

qolkaram — Sun, 23 Apr 2017 06:53:13 GMT

thanks for your reply but still there is an error

Re: syntax FOR SUBSET

Anil_Babu_Samineni — Sun, 23 Apr 2017 06:54:49 GMT

Can you show image

Re: syntax FOR SUBSET

qolkaram — Sun, 23 Apr 2017 06:56:36 GMT

Re: syntax FOR SUBSET

Anil_Babu_Samineni — Sun, 23 Apr 2017 07:00:12 GMT

This should work, May be this

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

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

If not, Please post sample application

Re: syntax FOR SUBSET

tresB — Sun, 23 Apr 2017 07:00:30 GMT

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.

Re: syntax FOR SUBSET

qolkaram — Sun, 23 Apr 2017 07:04:01 GMT

thanks ,it is working

Re: syntax FOR SUBSET

Anil_Babu_Samineni — Sun, 23 Apr 2017 07:05:04 GMT

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

Re: syntax FOR SUBSET

tresB — Sun, 23 Apr 2017 07:16:00 GMT

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