Variables in script to create a non-standard date range field?

stevelord — Tue, 06 Aug 2013 15:37:57 GMT

Hi I want to make "Campaign1" and "Campaign2" fields in my script to replace TestYear in the below chart aggr() expression.

if(If(BMI, Count(Aggr(Max(TestDate), ClientAccountName, UserId, TestYear))), only(if(TestDate>=vCohort1MinDate and TestDate<=vCohort1MaxDate, BMI)))

I want something like this, but stuck on syntax

if(TestDate>=vCohort1MinDate and TestDate<=vCohort1MaxDate) Dual([Campaign 1], 1)

if(TestDate>=vCohort2MinDate and TestDate<=vCohort2MaxDate) Dual([Campaign 2], 2) as Campaign

So on a pivot table I'd use Campaign instead of TestYear and get headers Campaign 1 and Campaign 2 instead of 2012 and 2013

Quick help would be much appreciated. I'm googling in the meantime. Thanks!

-Steve

topic Variables in script to create a non-standard date range field? in QlikView