topic IF statement in QlikView

IF statement

Wed, 30 Sep 2009 21:29:52 GMT

Hi,

How is in the set analyse with if statement

if(only select on Year and Month in Calendar, then sum(Value).

Thanks

Thu, 01 Oct 2009 03:24:48 GMT

Why not use IF()? You don't need to define a set, just use a conditional statement.

Thu, 01 Oct 2009 15:33:12 GMT

Hi,

i have 2 variable.

varstartdate

varenddate

how can i in statement the sum(value) from range varstartdate and varenddate become.

(>=varstartdate and <=varenddate sum(value))

Thanks

prieper — Thu, 01 Oct 2009 17:23:37 GMT

SUM(IF (YourDate > StartDate AND YourDate < EndDate, Values)=

HTH
Peter

Thu, 01 Oct 2009 18:39:39 GMT

Hi,

Thanks, sorry but it is not what i want.

i want the sum of Valuse in range from StartDate and EndDate, when i select the Calendar Year and select the Calendar Month

i have as Variable :

Startdate:

=Date (num(monthsstart(1,[Calendar.Year-Month] ,-12)))

Enddate:

=Date (num(monthsend(1,[Calendar.Year-Month] ,1)))

and Statement :

sum({<Calendar.Date ={">=$(=(Startdate)) <=$(=(Enddate))"}>} Sales)

but it is comming Sales from selected Year and month, not in the range from Startdate to Enddate.

is the formel not correct?

Thanks