Data summary

[#1]

Need to summarize data for current, YTD and Inception to date via set analysis!

[deepakk]

hi,

You can do that in two ways.

1) create two variables intialize the first  variable with the minimum date.

   vMinDate = makedate(max(Year)) ------------------------  this will create 01-Jan-2012

   Second variable

    vMaxDate  = Max(TransactionDate)...... this will store the maxmium transaction Date and it will change as per user selection.

Use it in your expression  = Sum({<Date={">= $(vMinDate) <= $(vMaxDate)">}  Amount)

2) You can try the below method.

Sum({$<Year={$(=Max(Year))},MonthYear= {"<=$(=Max(MonthYear))"}>}   Amount)

Deepak

[jagan]

Hi,

Try this expression

Sum({<DateField={">=$(=YearStart(Max(DateField)))<=$(=Max(DateField))">}  Sales)

This will calculate the Max Year(Current Year)  Jan 1 to the max date.

Regards,

Jagan.

[#4]

Thanks Jagan. I am trying to sum the sales in the following formats: 1) Total sales since the beginning of 2012 (Jan & Feb)2) Total sales for 2011 (whole year)3) Total sales for 3-years starting with Jan 2012 going back Regards, Ray

Date: Mon, 20 Feb 2012 02:59:21 -0500

From: qliktech@sgaur.hosted.jivesoftware.com

To: ref2ntx@hotmail.com

Subject: - Re: Data summary

QlikCommunity

Re: Data summary

created by jagan mohan in Community Corner - View the full discussion

Hi, Try this expression Sum({<DateField={">=$(=YearStart(Max(DateField)))<=$(=Max(DateField))">} Sales) This will calculate the Max Year(Current Year) Jan 1 to the max date. Regards,Jagan.

Reply to this message by replying to this email -or- go to the message on QlikCommunity

Start a new discussion in Community Corner by email or at QlikCommunity

© 1993-2011 QlikTech International AB

Copyright & Trademarks | Privacy | Terms of Use | Software EULA

[CELAMBARASAN]

Hi,

     I think your expecting 3 expressions?

     For Current year: Sum({<Date={">=$(=YearStart(Max(Date)))<=$(=Max(Date))"},Month=,Year=>} Sales)

     For 2011: Sum({<Month=,Year={$(=Max(Year)-1)}>} Sales)

     For 3 years back from previous month:Sum({<Date={">=$(=MonthStart(Max(Date),-37))<=$(=MonthEnd(Max(Date),-1))"}>})

Hope it helps

Celambarasan