Set Analysis - Multiple Variables - Syntax Issue?

cpiocpio — Thu, 12 Mar 2015 16:28:00 GMT

The following will return data when the line : FY_Period = {"<=$(=vFYPeriod)"}>},

is NOT used.

The variable FYPeriod is numeric and is defined as =Max( distinct FY_Period) and I tried without distinct

The aim is to return records for a particular year, up to and including the period , so currently period 11, which is March 2014 in the example since we are taking 1 from the FY.

=if(Vcurr='STG',

num(Sum ({<

FY={$(=vFY-1)},

FY_Period = {"<=$(=vFYPeriod)"}>},

product_group_a -= {'BMX','BPN','BSF','BST','BPI'},

SalesCat = {'MDE','MAT','MNL','M/O','IRL','MBE','MDK','MSE','MFR','MLU','PUN','VBN','SBM'}>}

val_base),

'£#,##0.00'),

num(Sum ({<

FY={$(=vFY-1)},

FY_Period = {"<=$(=vFYPeriod)"}>},

product_group_a -= {'BMX','BPN','BSF','BST','BPI'},

SalesCat = {'MDE','MAT','MNL','M/O','IRL','MBE','MDK','MSE','MFR','MLU','PUN','VBN','SBM'}>}

val_eur),

'€#,##0.00'))

Re: Set Analysis - Multiple Variables - Syntax Issue?

richard_chilvers — Thu, 12 Mar 2015 16:36:32 GMT

I am not an expert in set analysis, but I did notice that your expression FY_Period = {"<=$(=vFYPeriod)"}>} has 2 closing curly brackets } but only one opening {. I have a feeling that cannot be correct.

topic Set Analysis - Multiple Variables - Syntax Issue? in QlikView

Set Analysis - Multiple Variables - Syntax Issue?

Re: Set Analysis - Multiple Variables - Syntax Issue?