topic Re: Date range using variables in if statement in QlikView

Date range using variables in if statement

surface3 — Tue, 19 Feb 2019 15:19:25 GMT

I am trying to use if statements to sum two different fields. My current expression is as below:-

=if((Var_Metric_View=1) and (Month3='>$(vMonth_Current)<=$(vEndDateFY19))',

sum(Headcount),

if((Var_Metric_View=2) and (Month3='>$(vMonth_Current)<=$(vEndDateFY19))',

Sum([Total FTE])))

What I want to achieve is if Var_Metric_View is 1 and the date field 'Month3' is between two dates, which are stored as variables, then sum headcount

if Var_Metric_View is 2 and the date field is between the same two dates then sum FTE.

Any help A.S.A.P. would be much appreciated.

Re: Date range using variables in if statement

pradosh_thakur — Tue, 19 Feb 2019 15:34:36 GMT

=if($(Var_Metric_View )= 1  and Month3 >  $(vMonth_Current) and Month3 <=$(vEndDateFY19) ,

sum(Headcount),


if( $(Var_Metric_View)=2  and Month3 > $(vMonth_Current) and  Month3  <=$(vEndDateFY19),

Sum([Total FTE])
))

Re: Date range using variables in if statement

surface3 — Thu, 21 Feb 2019 12:20:07 GMT

Much appreciated.

Thank you!

Re: Date range using variables in if statement

pradosh_thakur — Thu, 21 Feb 2019 12:45:10 GMT

@surface3 if your query is answered please close the thread else let us know.