topic Re: Setting modifier in Set Analysis in QlikView

Setting modifier in Set Analysis

bimala0507 — Tue, 22 Apr 2014 03:51:34 GMT

Hi:

I have a requirement to show top 10 Materials with Highest Price difference for the period 2012-2013 and for 2013-2014 and I would like to build a dynamic modifier and based on that doing certain calculation.

E.g. If the Current Year Selected is 2012 and 2013 Than calculate

SUM

($(v_netprice_2013) - $(v_netprice_2012))

and

If The Current Year Selection is 2013 and 2014

SUM( {} $(v_netprice_214) - $(v_netprice_2013))

Is it acheivable by using Set analysis. Basically I want to select 2 years than it should show me Top 10 Materials for that particular years.

Attached the qvw for your reference. refer Dashboard sheet.

Re: Setting modifier in Set Analysis

MK_QSL — Tue, 22 Apr 2014 06:28:42 GMT

I haven't opened your QVW but let me give you code... you can modify as per your datamodel...

Considering that you will select only two months... you can have growth as per below

SUM({<Month = {'$(=Min(Month))'}>}Sales)

SUM({<Month = {'$(=Max(Month))'}>}Sales)

(SUM({<Month = {'$(=Max(Month))'}>}Sales)-SUM({<Month = {'$(=Min(Month))'}>}Sales))/SUM({<Month = {'$(=Min(Month))'}>}Sales)

Re: Setting modifier in Set Analysis

SergeyMak — Tue, 22 Apr 2014 06:43:56 GMT

Hi,

You don't need to use separate tables for different years.

You need to concatenate tables MAX_PO_XXXX in one table with the same column names and for every concatenated table you should create a Year field with appropriate value of year.

Than you will be able to use set analysis to calculate anything.

For example, Sum({$<Year={$(Max(Year))}>} [net price]) etc....