Expression Help

sona_sa — Thu, 04 Sep 2014 08:22:55 GMT

Hi ,

Scenario is like this,

My Expression =

If(Year = '2014',

((sum({$<Year = {2014},MONTH = {"<=$(vMonth)"},HalfYear,Quarter,Month>} SALES_AMT_USD/1000000)-sum({$<Year = {2014},MONTH = {"<=$(vMonth)"},HalfYear,Quarter,Month>} AOP_Value/1000000))

/sum({$<Year = {2014},MONTH = {"<=$(vMonth)"},HalfYear,Quarter,Month>} AOP_Value/1000000)*100),

((sum({$<Year={$(=max(Year))},MONTH={'<=$(=Max(MONTH))',Quarter,HalfYear, Month}>} SALES_AMT_USD/1000000)-sum({$<Year={$(=max(Year))},MONTH={'<=$(=Max(MONTH))',Quarter,HalfYear, Month}>} AOP_Value/1000000))

/sum({$<Year={$(=max(Year))},MONTH={'<=$(=Max(MONTH))',Quarter,HalfYear, Month}>} AOP_Value/1000000)*100))

By using this expression I am getting -100 value, So I want to replace -100 with 0.

Thanks

Re: Expression Help

MK_QSL — Thu, 04 Sep 2014 08:31:45 GMT

IF(YourExpression < 0, 0, YourExpression)

Re: Expression Help

Anonymous — Thu, 04 Sep 2014 08:38:59 GMT

did you check your Expression step by step

might it be that the single part are correct?

(0-100)/(100*100) results in -100

SALES_AMT_USD does return correct data with the specified set Analysis Options?

topic Re: Expression Help in QlikView

Expression Help

Re: Expression Help

Re: Expression Help