topic Re: Compare field in Set Analysis in QlikView

Compare field in Set Analysis

Thu, 20 Mar 2014 10:09:32 GMT

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

Re: Compare field in Set Analysis

PrashantSangle — Thu, 20 Mar 2014 10:15:41 GMT

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,

Re: Compare field in Set Analysis

daveamz — Thu, 20 Mar 2014 10:17:57 GMT

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

Re: Compare field in Set Analysis

Thu, 20 Mar 2014 10:21:55 GMT

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

Regards

Vinay

Re: Compare field in Set Analysis

Thu, 20 Mar 2014 10:25:57 GMT

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

Re: Compare field in Set Analysis

sunilkumarqv — Thu, 20 Mar 2014 10:32:40 GMT

Try this

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

Re: Compare field in Set Analysis

Thu, 20 Mar 2014 10:47:40 GMT

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.

Re: Compare field in Set Analysis

CELAMBARASAN — Thu, 20 Mar 2014 10:56:04 GMT

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))

Re: Compare field in Set Analysis

Thu, 20 Mar 2014 11:13:35 GMT

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?