Calculated Dimension AGGR function + Set Analysis

Sun, 24 Mar 2013 21:21:43 GMT

Hi guys,

i'm trying to use a calculated dimension to define products as "New Launches" or "Existing" products.

I've got a similar expression that calculates what price bracket they fall into, its working nicely also using AGGR.

I am having an issue with the time periods specifically. Think my set analysis is wrong.

I want the user to select some sequential months and for the expression to compare the selected time period to the previous (unselected time period) to determine whether it is new or not. So if there are sales in the selected time period and NO sales for the period before then the product is logically a "New Launch" or else it is an existing product.

This expression below isn't working and I'm sure it's because of the set analysis trying to exclude the selected period.

if(aggr(if(Period<= vMaxMonth and Period >= vMinMonth,sum(Value)),Description,Market) > 0 
     and sum({<Period=>}aggr(if(Period<vMinMonth and Period>=vMinMonthTotal,Value),Description,Market)) = 0 , 'New Launch', 'Existing')

vMaxMonth is a variable = the latest month selected

vMinMonth is a variable = the earliest month selected

vMinMonthTotal is the earliest month in the database

Value is the Sales

Period is my time dimension.

Description is the products.

Market is the total market.

Thanks for your help!

Cindy

Re: Calculated Dimension AGGR function + Set Analysis

somenathroy — Mon, 25 Mar 2013 04:19:22 GMT

Can you pls. upload a sample app.

Re: Calculated Dimension AGGR function + Set Analysis

Tue, 26 Mar 2013 09:59:28 GMT

Hi guys,

I figured it out myself!

Seems I had my "sum" expression in the wrong place.

Thanks

Cindz

Re: Calculated Dimension AGGR function + Set Analysis

sr_qlikview — Fri, 29 Mar 2013 13:24:03 GMT

can you please share the corrected expression.

topic Re: Calculated Dimension AGGR function + Set Analysis in QlikView

Calculated Dimension AGGR function + Set Analysis

Re: Calculated Dimension AGGR function + Set Analysis

Re: Calculated Dimension AGGR function + Set Analysis

Re: Calculated Dimension AGGR function + Set Analysis