Using Greater Than in Set Analysis

[tmumaw]

I am trying to use the following : Count ({<CampCreateDate {">= [Document Date]"}>} DISTINCT Contract_ID), but keep getting an error.  I want to count any contract where campaign create date is greater than or equal to document date.

Thanks
Thom

[etay_netintent]

Hi

Set analysis only recognised '=' there fore you have to use ='<='

Look at this example from the help

Sum({<Year = {">=1978"}> } Sales)

Etay

[etay_netintent]

Hi

for starters Try CampCreateDate = {

Which version are you working with ?? in addition to adding the = Set analysis had a problem comparing dates. We turn the date into a number and compare on that.

Etay

[CELAMBARASAN]

Hi,

     Check with this

Count ({<CampCreateDate {"=Aggr(If(CampCreateDate >=[Document Date],CampCreateDate), CampCreateDate)"}>}DISTINCT Contract_ID)

Celambarasan

[tmumaw]

Set modifier error

[tmumaw]

We are running 10 SR 4

[CELAMBARASAN]

Hi,

     typo mistake

Count ({<CampCreateDate ={"=Aggr(If(CampCreateDate >=[Document Date],CampCreateDate), CampCreateDate)"}>}DISTINCT Contract_ID)

Or check with this also

Count ({<CampCreateDate ={"=Aggr(If(CampCreateDate >=[Document Date],CampCreateDate), CampCreateDate,[Document Date])"}>}DISTINCT Contract_ID)

Celambarasan

[danielrozental]

Sorry but set analysis won't work for that. Reason is it's not processed as row per row basis, the set analysis result set is one and gets processed before the object does.

You need to do something like this or you can just add a flag in the script for those documents

Count (DISTINCT if(CampCreateDate >= [Document Date],Contract_ID))

[#9]

Hi Thom!!

Are you still interested for solution?

I didn't recognize the post date!!!

However this expression works properly:

Supposing your pivot table has a structure like this:

Contract_ID - CampCreateDate - Document Date

the right expression is:

count ({< CampCreateDate= {'>=$(=date(max(aggr(max([Document Date]),Contract_ID&CampCreateDate&[Document Date])),'DD/MM/YYYY'))'} >} DISTINCT Contract_ID)  

If you have problem I can send you my sample Qvw!

Let me know...

Bye!!

[SunilChauhan]

simply use below code

Count ({<CampCreateDate= {">=$(= [Document Date])"}>} DISTINCT Contract_ID)

hope this helps