Need some help with defining a set analysis formula

Anonymous — Fri, 09 Feb 2018 22:19:30 GMT

Hi Experts,

I'm having trouble correctly defining a set analysis expression in a script. When I use the formula directly in a chart it works as intended. When I try to define it in the script I haven't been able to make it work. Below is a simplified script demonstrating the problem with the qvw attached. When SelectedYear is selected the CYSales value should show the sales for that year.

The Sales chart in the qvw shows the behavior of the formula applied in the script, the chart and via Settings->Valriable Overview

The column labeled 'CYSales_Chart' demonstrates the desired results. Ideally I'd also like to use the CurrentYear variable as opposed to Max(SelectedYear) in the formula.

Any help would be greatly appreciated.

Thanks in advance,

--------

set CurrentYear = Max(SelectedYear);

set LastYear = Max(SelectedYear)-1;

set CYSales_Script = sum( {$<Year = {$(#=Max(SelectedYear))}>} Sales );

Sales:

load * Inline [

Customer, Year, Sales

CustA, 2016, 10000,

CustA, 2017, 12000,

CustA, 2018, 15000,

CustB, 2016, 1000,

CustB, 2017, 1200,

CustB, 2018, 1500,

CustC, 2016, 100,

CustC, 2017, 120,

CustC, 2018, 150,

];

Years:

load Distinct Year as SelectedYear Resident Sales;

Re: Need some help with defining a set analysis formula

swuehl — Fri, 09 Feb 2018 23:17:57 GMT

Have a look at

Re: Stop Dollar Sign Expansion in the script (Escape Character ??? )

Re: Need some help with defining a set analysis formula

Anonymous — Mon, 12 Feb 2018 14:26:04 GMT

Hi Stefan - that works perfectly. Thanks for your help.

topic Need some help with defining a set analysis formula in QlikView

Need some help with defining a set analysis formula

Re: Need some help with defining a set analysis formula

Re: Need some help with defining a set analysis formula