topic LOGIC Required in QlikView

LOGIC Required

abhaysingh — Wed, 24 Sep 2014 08:11:48 GMT

i want to see my PROJECTED SALES for current Month ONLY when I select back Month or Years it should give me NOT APPLICABLE

Projected sales calculated as SUM(SALES)

kindly help

Re: LOGIC Required

Anonymous — Wed, 24 Sep 2014 08:15:25 GMT

sum({$month=()sales})

i hope it works if not let me know

Re: LOGIC Required

PrashantSangle — Wed, 24 Sep 2014 08:16:17 GMT

Hi,

Just write.

It will give you only current Month Sales

Sum({<Datefield={">=MonthStart(Today())"}>}Sales)

Regards,

Re: LOGIC Required

abhaysingh — Wed, 24 Sep 2014 08:23:08 GMT

Not working

Re: LOGIC Required

abhaysingh — Wed, 24 Sep 2014 08:25:25 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

er_mohit — Wed, 24 Sep 2014 08:42:43 GMT

Try this

Sum( {< Date={'>=$(=MonthStart(Max(Date), 0))<=$(=MonthEnd(Max(Date), 0))'} >} PROJECTEDSALES)

Make sure your Date format is same

or Try this

Sum( {<Year={'=$(=Max(Year)),Month={'=$(Max(Month))} >} PROJECTEDSALES)