Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
akuligod
New Contributor

Sum logic

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

  • trying to sum campaign data from campaign date to 3 months later.
  • checked all date formatting.

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

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

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

          >} DISTINCT Design_Parts)

stalwar1

4 Replies
Highlighted
vishsaggi
Esteemed Contributor III

Re: Sum logic

Did you try like

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

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

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

          >} DISTINCT Design_Parts), Dimension1, Dimension2))

Highlighted
akuligod
New Contributor

Re: Sum logic

Sir,

This is not working.

Dim 1, Dim2 not recognized.

Highlighted

Re: Sum logic

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

Highlighted
akuligod
New Contributor

Re: Sum logic

Yes Sir.