topic last year and current year in QlikView

last year and current year

Wed, 07 Dec 2011 18:29:13 GMT

Hi ,

I have a report which compares current year sales with previous year sales.I have attached the doc which shows my report.

As in the example when I select the subcain-MITRI for fiscal year-2012 and month as oct I get sales in the current for 4 stores which is good but for last year the sales are shown for 2 stores because last year the subchain was MILEAS and now it changed to MITRI.Is there a easy way to show up the last year stores also under subchain MITRI.I cant harcode as there would be many occurances for this.

Pls help.Pls let m eknow if you need additional info.

Thanks,

Swetha

last year and current year

Thu, 08 Dec 2011 09:31:42 GMT

Hi Swetha,

Can you sent a small test-app, because i can't open your document.

Halmar

last year and current year

Miguel_Angel_Baeyens — Thu, 08 Dec 2011 12:07:41 GMT

Hi Swetha,

I don't if you have already but check this application that does year to date analysis using set analysis and flag fields in the calendar table, plus some variables in calendar objects.

Hope that helps.

Miguel

last year and current year

SunilChauhan — Thu, 08 Dec 2011 12:26:45 GMT

use below code Sum({$<Year={$(=only(Year)}Sale)_Sum({$<Year={$(=only(Year)-1}Sale)

last year and current year

Thu, 08 Dec 2011 14:13:26 GMT

Thanks Miguel!

I have done all the comparison b/w previous year and current year sales and everything looks good .Now only problem is in my app as I have shown in the doc the the sales for previous year also need to come under the same filed value as current year.

As I have shown for current year the store-0925,1139,1159,3058 are shown under MITRI(subchain field value) but for last year store-1159 and 3058 are shown as 0 because they belong to MILEAS(subchain field value).I mean the subchain name changed from MILEAS to MITRI from last year to current year.Please let me know how do I proceed.

Thanks,

Swetha

Re: last year and current year

Thu, 08 Dec 2011 14:14:07 GMT

Thanks Miguel!

Thanks,

Swetha