topic Re: Sum logic in QlikView

Sum logic

akuligod — Wed, 08 Aug 2018 23:14:52 GMT

The formula below does not seem to work. Kindly suggest corrections.

Count({$<DataType={'Registration'},

RegItemStatus={'Approved','Expired'},

RegItemReviewDate_YYYYMM={">$(=CampainDate_YYYYMM)<$(=CampainDateAfter_YYYYMM)"}

>} DISTINCT Design_Parts)

vishsaggi — Thu, 09 Aug 2018 02:04:40 GMT

Did you try like

Sum(Aggr(Count({$<DataType={'Registration'},

RegItemStatus={'Approved','Expired'},

RegItemReviewDate_YYYYMM={">=$(=CampainDate_YYYYMM)<$(=CampainDateAfter_YYYYMM)"}

>} DISTINCT Design_Parts), Dimension1, Dimension2))

akuligod — Thu, 09 Aug 2018 16:21:04 GMT

Sir,

This is not working.

Dim 1, Dim2 not recognized.

sunny_talwar — Thu, 09 Aug 2018 16:32:48 GMT

Is this similar to this thread? Sum within a date range

akuligod — Thu, 09 Aug 2018 16:35:26 GMT

Yes Sir.