topic Re: OR condition in set analysis in QlikView

OR condition in set analysis

Thu, 06 Nov 2014 11:56:05 GMT

Hi All,

How we can write OR condition in set analysis.

Sum({$<[Distribution Channel Desc]={'A','B','C'} or ([Distribution Channel Desc] = {'D'} and customerno = {'1','2','3'})>} Sales)

Thanks

Re: OR condition in set analysis

MK_QSL — Thu, 06 Nov 2014 11:58:47 GMT

SUM({$<[Distribution Channel Desc]={'A','B','C'}>*<[Distribution Channel Desc] = {'D'},customerno = {'1','2','3'} >}Sales)

Re: OR condition in set analysis

Anonymous — Thu, 06 Nov 2014 12:02:19 GMT

Try:

Sum({<[Distribution Channel Desc]={'A','B','C'}>+

<[Distribution Channel Desc] = {'D'} , customerno = {'1','2','3'})>} Sales)

Marc.

Re: OR condition in set analysis

Thu, 06 Nov 2014 12:02:49 GMT

what is the important of * here

Re: OR condition in set analysis

simondachstr — Thu, 06 Nov 2014 12:03:22 GMT

* is an intersection that returns a set consisting of the records that belong to both operands (typical AND)

I believe a Union + would be more appropriate in this case.

SUM({$<[Distribution Channel Desc]={'A','B','C'}>+<[Distribution Channel Desc] = {'D'},customerno = {'1','2','3'} >}Sales)

Re: OR condition in set analysis

perumal_41 — Thu, 06 Nov 2014 12:04:12 GMT

Hi,

Try below expression

SUM({$<[Distribution Channel Desc]={'A','B','C'}>+<[Distribution Channel Desc] = {'D'},customerno = {'1','2','3'} >}Sales)

Re: OR condition in set analysis

ashfaq_haseeb — Thu, 06 Nov 2014 12:05:59 GMT

+ for Union * For Intersection

Go with this

Sum({<[Distribution Channel Desc]={'A','B','C'}>+

<[Distribution Channel Desc] = {'D'} , customerno = {'1','2','3'})>} Sales)

Check the attached document for more details

Regards

ASHFAQ

Re: OR condition in set analysis

Kushal_Chawda — Thu, 06 Nov 2014 12:23:47 GMT

Try

SUM({$<[Distribution Channel Desc]={'A','B','C'}>+<[Distribution Channel Desc] = {'D'},customerno = {'1','2','3'} >}Sales)

Re: OR condition in set analysis

perumal_41 — Thu, 06 Nov 2014 12:32:28 GMT

Try this

Sum({$<GIDRDDNullFlag = {'0'},[Business Segment] = {'Power Components','Power Equipment'},

[Suspension Flag - MM]={'#'},Pole={'NA'},[Item Category]={'*'} -{'ZSPK','ZSK1'},newDueIndicator={'1.OVD'},

[PSI Code]={'*'} - {'S11'},[Sold To No]={'*'} - {'9950016'},[Distribution Channel Desc]={'Distribution','Other','Direct'} > +

<GIDRDDNullFlag = {'0'},[Business Segment] = {'Power Components','Power Equipment'},

[Suspension Flag - MM]={'#'},Pole={'NA'},[Item Category]={'*'} -{'ZSPK','ZSK1'},newDueIndicator={'1.OVD'},

[PSI Code]={'*'} - {'S11'},[Sold To No]={'*'} - {'9950016'}, [Distribution Channel Desc] = {'Intercompany'},[Sold To No] = {'9465653','9465654','9465655','9465716','9465718','9465720'}>}

} sales)

Re: OR condition in set analysis

rubenmarin — Thu, 06 Nov 2014 12:41:40 GMT

Hi, maybe using different sum is easier:

Sum({$<GIDRDDNullFlag = {'0'},[Business Segment] = {'Power Components','Power Equipment'},

[Suspension Flag - MM]={'#'},Pole={'NA'},[Item Category]={'*'} -{'ZSPK','ZSK1'},newDueIndicator={'1.OVD'},

[PSI Code]={'*'} - {'S11'},[Sold To No]={'*'} - {'9950016'},[Distribution Channel Desc]={'Distribution','Other','Direct'}>} sales)

+ Sum({$<GIDRDDNullFlag = {'0'},[Business Segment] = {'Power Components','Power Equipment'},

[Suspension Flag - MM]={'#'},Pole={'NA'},[Item Category]={'*'} -{'ZSPK','ZSK1'},newDueIndicator={'1.OVD'},

[PSI Code]={'*'} - {'S11'},[Sold To No]={'9465653','9465654','9465655','9465716','9465718','9465720'}, [Distribution Channel Desc] = {'Intercompany'}>} sales)

Re: OR condition in set analysis

perumal_41 — Thu, 06 Nov 2014 12:58:24 GMT

Hi ,

This expression get ur expected value,

first try expression in your application and check value matching or not.