Compare field in Set Analysis

[#1]

Hi all,

See below expression in Pivot table,

its working on first condition but not working on second.

Its does not pick up the Sdate field.

(see attached pic when I hover the mouse on column we can't see Sdate selected its Show {'>= <=18/03/......}

if(vFromDate > Sdate1,sum({<T_Date= {'>=$(vFromDate) <=$(vToDate)'} >}Tday),
sum({<T_Date= {'>=$(DATE(Sdate)) <=$(vToDate)' }>} Tday))

What is wrong in above expression?

FYI:

vFromDate & vToDate are Variables

Sdate, T_Date & Tday are fields

[PrashantSangle]

Hi,

It looks like issue not with 'Sdate'

try this,

if($(vFromDate) > Sdate1,sum({<T_Date= {'>=$(vFromDate) <=$(vToDate)'} >}Tday),
sum({<T_Date= {'>=$(DATE(Sdate)) <=$(vToDate)' }>} Tday))

regards,

[daveamz]

Hi,

     You missed out a "=" in $(DATE(Sdate))

Try:

if(vFromDate > Sdate1,sum({<T_Date= {'>=$(vFromDate) <=$(vToDate)'} >}Tday),
sum({<T_Date= {'>=$(=DATE(Sdate)) <=$(vToDate)' }>} Tday))

Regards,

David

[#4]

No its not Working. still same, it not start from Sdate when condition is wrong.

Regards

Vinay

[#5]

No its same.

Actually want I want...

If vFromDate>Sdate then

     sum of Tday between vFromDate to vToDate

          else

      sum of Tday between Sdate to vToDate

[sunilkumarqv]

Try this

if(vFromDate >Sdate1 ,sum({<T_Date= {'>=$(vFromDate) <=$(vToDate)'} >}Tday),sum({<T_Date= {">=$(=(Sdate))<=$(=(vToDate))"}>} Tday))

[#7]

I have tried without DATE but still not working.

if(vFromDate > Sdate1,sum({<T_Date= {'>=$(vFromDate) <=$(vToDate)'} >}Tday),
sum({<T_Date= {'>=$(Sdate) <=$(vToDate)' }>} Tday))

also tried..

if(vFromDate > Sdate1,sum({<T_Date= {'>=$(vFromDate) <=$(vToDate)'} >}Tday),
sum({<T_Date= {'>=(Sdate) <=$(vToDate)' }>} Tday))

all above expression it give me result but its wrong. It dose not start with Sdate when condition is not satisfied.

[CELAMBARASAN]

I don't know how your data model is, but I hope below will work

if(vFromDate > Sdate1, sum({<T_Date= {">=$(=vFromDate)<=$(=vToDate)"} >}Tday),
sum({<T_Date= {"=T_Date>=Sdate and T_Date <=$(=vToDate)" }>} Tday))

[#9]

Hi Celambarasan,

No its still same and give me wrong sum of Tday.

see attached, when I hover mouse on column show Sdate1 as its is but is suppose to display some date.

if I use below expression with hard coded date instead of filed Sdate1 then its working fine.

if(vFromDate > Sdate1,sum({<T_Date= {'>=$(vFromDate) <=$(vToDate)'} >}Tday),
sum({<T_Date= {'>=10/03/2014 <=$(vToDate)' }>} Tday))

So why can't use field Sdate1?