Set analysis or ?

Anonymous — Mon, 12 Nov 2012 12:13:39 GMT

Need help with something.Please find attached

Notice the current year and the months(2nd quarter) selected but the the total recoveries includes the 1st quarter ie Jan,Feb and Mar and also the previous years.

Now i would want to separate the recoveries into previous years and the 1st quater

Re: Set analysis or ?

renjithpl — Mon, 12 Nov 2012 12:38:18 GMT

Try something like this

You can create a calendar with Quarters using,

DayNumberOfQuarter in your load statement, then in the set you can use that field to get max Quarter or previous Quarter.

// for Max Month recovery
Sum( {<Year=, Month =, MONTH_NAME = {"$(=MonthName(max(MONTH_NAME)))"} >} Recoveries)

// for max Year recovery
Sum( {<YEAR=, Month =, YEAR = {"$(=(max(YEAR)))"} >} >} Recoveries)

//for prev month recovery

sum({<YEAR=,
Month =,
MONTH_NAME = {"$(=MonthName(AddMonths(max(MONTH_NAME), -12)))"}
>} Recovery)

// for Last Year recovery
Sum( {<YEAR=,
Month =,
YEAR = {"$(=(max(YEAR)-1))"}
>} Recoveries)

regards

Ren

topic Set analysis or ? in QlikView

Set analysis or ?

Re: Set analysis or ?