topic Re: Re: Expression Help in QlikView

Expression Help

sona_sa — Fri, 12 Sep 2014 09:24:39 GMT

Hi,

Can anyone help me on below expression.

I have my expression - sum(aggr( Fabs((Sum(SALES_QTY) - Sum(SOP_Cts))/1000), CATEGORY))

Now With some condition I have to change in

If(Year ='2014',(sum({$<Year = {2013,2014},MONTH = {"<=$(vMonth)"},HalfYear,Quarter>} SALES_AMT_USD/1000000)),

If(Year = '2013',(sum({$<Year={2013},MONTH = {7,8,9,10,11,12},HalfYear,Quarter>}SALES_AMT_USD)/1000000),

(Sum(SALES_AMT_USD)/1000000)))

Previous one I have to convert in

If(Year ='2014',(sum({$<Year = {2013,2014},MONTH = {"<=$(vMonth)"},HalfYear,Quarter>} SALES_AMT_USD/1000000)),

If(Year = '2013',(sum({$<Year={2013},MONTH = {7,8,9,10,11,12},HalfYear,Quarter>}SALES_AMT_USD)/1000000),

(Sum(SALES_AMT_USD)/1000000)))

Thanks

Re: Expression Help

MK_QSL — Fri, 12 Sep 2014 09:26:04 GMT

What you want ?

Re: Expression Help

Fri, 12 Sep 2014 09:31:10 GMT

Agree with Manish, not sure what you are asking here!

Re: Expression Help

sona_sa — Fri, 12 Sep 2014 09:34:57 GMT

I want the same aggr function whatever I am using in 1st expression i.e - sum(aggr( Fabs((Sum(SALES_QTY) - Sum(SOP_Cts))/1000), CATEGORY))

Same should be in - sum({$<Year = {2013,2014},MONTH = {"<=$(vMonth)"},HalfYear,Quarter>} SALES_AMT_USD/1000000))

Re: Expression Help

MK_QSL — Fri, 12 Sep 2014 09:48:00 GMT

Can you provide sample data or sample application?

Re: Expression Help

sona_sa — Fri, 12 Sep 2014 10:13:53 GMT

Yes Please find the attached xls.

for Actual - 2014 Data is available till Mar and for 2013 - from Jul to Dec and Plan is available for 2013 from JAN to DECEMBER, I want YTD. By Category wise with (Acual - Plan)/1000

Re: Re: Expression Help

sona_sa — Fri, 12 Sep 2014 10:14:45 GMT

Yes Please find the attached xls.

for Actual - 2014 Data is available till Mar and for 2013 - from Jul to Dec and Plan is available for 2013 from JAN to DECEMBER, I want YTD. By Category wise with (Acual - Plan)/1000

Re: Expression Help

MK_QSL — Fri, 12 Sep 2014 10:22:58 GMT

Create a Pivot Table

Dimension

Re: Re: Expression Help

sona_sa — Fri, 12 Sep 2014 10:50:47 GMT

I want diff. between Actual - Plan

sum(Aggr( Fabs(Sum({$<Year = {2014},MONTH = {"<=$(vMonth)"}>}((SALES_QTY)-(SOP_Cts))/1000)),CATEGORY))

For Output please find the attached

Re: Re: Expression Help

sona_sa — Fri, 12 Sep 2014 10:52:08 GMT

I want diff. between Actual - Plan

sum(Aggr( Fabs(Sum({$<Year = {2014},MONTH = {"<=$(vMonth)"}>}((SALES_QTY)-(SOP_Cts))/1000)),CATEGORY))

Re: Expression Help

MK_QSL — Fri, 12 Sep 2014 11:03:45 GMT

Can you tell me how you achieve below?

1/5-COLL DLX - W 2

0.3480

1.3328

0.9848

Re: Expression Help

sona_sa — Fri, 12 Sep 2014 11:17:28 GMT

finished from my side. OK Thanks