Set Analysis

[hkg_qlik]

TypeOfIncident='Request' && (IsSecondBreached ='True' || IsThirdBreached='True' || IsResolutionBreached ='True')

how can we convert the above condition to a set analysis statement?

regards

H

[CELAMBARASAN]

Hi,

     Check with this,

     Sum({<TypeOfIncident={'Request'}>*(<IsSecondBreached ={'True'}>+<IsThirdBreached={'True'}>+<IsResolutionBreached ={'True'}>)>} FieldName)

Celambarasan

[hkg_qlik]

Hi,

I am looking to get something like this:

Count({1<[Type of Incident] = {"Request"}, [Is SecondBreached] = {"True"} or [IsThirdBreached]={'True'} or

TypeOfIncident={'Request'}>}Distinct [Counter Incident Number])

Does this helps. how to get the 'or' condition in set analysis?

Regards,

H

[CELAMBARASAN]

Hi,

     In set analysis you can use * for 'and' like below between 2 sets, then + for 'or' between 2 sets.

Count({1<TypeOfIncident={'Request'}>*(<IsSecondBreached ={'True'}>+<IsThirdBreached={'True'}>+<IsResolutionBreached ={'True'}>)>} Distinct [Counter Incident Number])

Did you checked like this?it doesn't gives you the same result?

Celambarasan

[hkg_qlik]

Count({1<TypeOfIncident={'Request'}>*(<IsSecondBreached ={'True'}>+<IsThirdBreached={'True'}>+<IsResolutionBreached ={'True'}>)>} ---> Its showing error in expression here for the part i have marked in bold.

Distinct [Counter Incident Number])

[CELAMBARASAN · Accepted solution]

Hi,

     Its typo mistake.

Count({1<TypeOfIncident={'Request'}>*(<IsSecondBreached ={'True'}>+<IsThirdBreached={'True'}>+<IsResolutionBreached ={'True'}>)} Distinct [Counter Incident Number])

Now check with it

Celambarasan

[hkg_qlik]

Thanks its working now.

H