topic Set Analysis in QlikView

Set Analysis

hkg_qlik — Wed, 06 Jun 2012 18:52:52 GMT

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

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

regards

Set Analysis

CELAMBARASAN — Wed, 06 Jun 2012 19:11:54 GMT

Hi,

Check with this,

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

Celambarasan

Set Analysis

hkg_qlik — Wed, 06 Jun 2012 19:26:55 GMT

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,

Set Analysis

CELAMBARASAN — Wed, 06 Jun 2012 19:34:41 GMT

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

Set Analysis

hkg_qlik — Wed, 06 Jun 2012 19:56:16 GMT

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])

Set Analysis

CELAMBARASAN — Wed, 06 Jun 2012 19:59:33 GMT

Hi,

Its typo mistake.

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

Now check with it

Celambarasan

Set Analysis

hkg_qlik — Wed, 06 Jun 2012 20:24:20 GMT

Thanks its working now.