topic Logic required RUN RATE in QlikView

Logic required RUN RATE

abhaysingh — Wed, 24 Sep 2014 08:36:02 GMT

this is my run Rate logic=

(NUM(sum([Prd. Value]) / vCrore / if(GetFieldSelections(FMonth)=month(today())
and GetFieldSelections (YEAR) ='14-15' , Day(date(today()) ), ((count(Days)))),'#.##') )

and I want it to run it for current month and year only when I will select back month it should give me NOT APPLICABLE

Re: Logic required RUN RATE

anbu1984 — Wed, 24 Sep 2014 08:45:19 GMT

=If(GetFieldSelections(FMonth)<>month(today()) Or and GetFieldSelections (YEAR) < Year(Today()),'NOT APPLICABLE',YOUR_RUN_RATE_EXPR)

Re: Logic required RUN RATE

Wed, 24 Sep 2014 08:49:41 GMT

Abhay, You can try like this:

if((GetFieldSelections(FMonth)=month(today()) and GetFieldSelections(YEAR) ='14-15'),

NUM((sum([Prd. Value]) / vCrore /count(Days)),0.00),'Not Applicable')