U R G E N T - Set Analysis Help required

[vikasmahajan]

Dear All

I have following expression for calculating sales as per user selected month and year ,

I want to display same set of expression for last year as per user selected month and year  dynamically.

(SUM({$<FiscalYear={$(=max(FiscalYear))}>}[Sales Invoice Qty])

-

SUM({$<FiscalYear={$(=max(FiscalYear))}>}[Sales Return Qty])

)/1000

Thanks in advance

Vikas

[vikasmahajan]

Hello I have attached the demo example please help me ,

IF user selects  Month and year then sales related to month and year should display vs last year same months and year sets.

Thanks

Vikas

[MayilVahanan]

Hi

Its work fine. When u select the fiscal year.

If u select fiscal year - 2013, its display 2013 value and 2012 value

For 2012 , there is no data, so it display zero.

Please find attachment

[vikasmahajan]

Thanks I thing  you have not understand what exact I want

If user will select fin year 2013 and month  may & june I want to display  may+june sale (2013 ) vs  may+june(2012) I want to display,

Is there any solutiion ?

[tresesco]

Vikas,

Expression should be:

SUM({$<FinancialYear=,FiscalYear={$(=(Max(FiscalYear)-1))}>} [Sales Invoice Qty])

PFA

[vikasmahajan · Accepted solution]

Thanks to all

Finally resolve with following link

http://community.qlik.com/message/313514#313514

Vikas

[paulyeo11]

Hi tres

i like the 2 link you posted. very useful info.