topic Re: help in set analysis in QlikView

help in set analysis

Anonymous — Sun, 13 Sep 2015 12:23:13 GMT

Hi All,

i am calculating values for YearToGo in set expression.

My requirement is i have calculated MTD,YTD

I am struck wih calculating YearToGo.

I want the sum of values which are not included in the selection.

let suppose I have months jan to dec .IF i select jan i have value YTD,MTD .

IF i select jan i need to calculate YearToGo which is sum of Feb to Dec .

Any ideas are appreciated

Sun, 13 Sep 2015 13:34:31 GMT

Hi RGV,

try to use

sum({<date={'>= $(SelectedDate) <= $(YearToGo)'}>}Value)

Where date is your date filed,

and SelectedDate is a variable storing the selected day.

and YearToGo is a variable storing the end of year using YearEnd Function.

be careful to the date format in variables.

hope it is helpful to you.

Sun, 13 Sep 2015 13:43:44 GMT

Use the below expression:

Sum(

{<DateField={">=$(AddMonths(MonthStart(Max(DateField)),1))<=$(AddMonths(MonthEnd(Max(DateField)),12))"}>} SaleAmount

)

Anonymous — Mon, 14 Sep 2015 07:32:24 GMT

Hi,

try:

Sum({$<Date = {">=$(=AddMonths(MonthStart(Max(Date)), 1))<=$(=AddMonths(MonthEnd(Max(Date)), 11))"}>} Sales)

Anonymous — Mon, 14 Sep 2015 10:20:20 GMT

Hi All,

I tried with below expression.

sum({<Month={'>$(vSeletedMonth)'}>}sales)

vSelectedMonth = max(Month)

Even the above is also working fine .