topic Re: Set Analysis - Variable within the previous 30 days in QlikView

Set Analysis - Variable within the previous 30 days

Anonymous — Tue, 11 Jul 2017 07:48:04 GMT

Hi I have created a set analysis, where I only want to include a sum of the FTE if the stage in in Authorisation and the Modification date is within the previous 30 days. It works fine without the variable, but then returns zero when I include the variable.

I have created a variable to identify the date 30 days ago. When I try to apply it to my set analysis it doesn't work. What am I doing wrong.

=Sum(Aggr(Sum(

Recruit.Vacancy_Stage={'Authorisation'},

[Recruit.Vacancy Modified Date]={'$(>=v30DaysOld)'}

Recruit.Vacancy_FTE),Recruit.empjobref))

Cheers

Phil

Re: Set Analysis - Variable within the previous 30 days

antoniotiman — Tue, 11 Jul 2017 07:52:45 GMT

Hi Phil,

maybe

=Sum(Aggr(Sum(

Recruit.Vacancy_Stage={'Authorisation'},

[Recruit.Vacancy Modified Date]={'>=$(=v30DaysOld)'}

Recruit.Vacancy_FTE),Recruit.empjobref))

Regards,

Antonio

Re: Set Analysis - Variable within the previous 30 days

Anil_Babu_Samineni — Tue, 11 Jul 2017 07:53:47 GMT

Or this?

=Sum(Aggr(Sum(

Recruit.Vacancy_Stage={'Authorisation'},

[Recruit.Vacancy Modified Date]={'$('>=' & =v30DaysOld)'}

Re: Set Analysis - Variable within the previous 30 days

Anonymous — Tue, 11 Jul 2017 09:16:40 GMT

This didn't work, but eventually sorted it by changing the variable to:

v30DaysOld=Date((Today()-30))

Previously set at : v30DaysOld=(Today()-30)

Re: Set Analysis - Variable within the previous 30 days

Kushal_Chawda — Tue, 11 Jul 2017 09:22:03 GMT

try like below

Sum(Aggr(Sum(

Recruit.Vacancy_Stage={'Authorisation'},

[Recruit.Vacancy Modified Date]={">=$(v30DaysOld)"}

Recruit.Vacancy_FTE),Recruit.empjobref))