topic Re: Calculated Dimension in Set Analysis in QlikView

Calculated Dimension in Set Analysis

Wed, 30 Mar 2016 21:26:51 GMT

Hi all, just wondering if anybody can point me in the right direction.

I'm simply trying to use a calculated Dimension within Set analysis Expression to ignore any 'Section' filters, so if user filters by Section it won't filter the chart as 'Section' is not a direct dimension in the chart, tried a few things but no luck.

This is the current Expression and Calculated Dimension.

//Calculated Dimension used as filter

= if(FileType = '$(vR4_IntSwitch)',if(left(Section,1)='B','ELECTRICITY'),null())

//Need to include above to stop chart filtering on 'Section'
=sum({<MonthYear=,Month=,Section=>}

aggr(sum({<SupplierName =,MonthYear=,Month=,Section=>}AdjustedMeasure),Month,MonthYear,SupplierGroup,FileType,

Section,Description)
)

Many thanks!

Re: Calculated Dimension in Set Analysis

swuehl — Wed, 30 Mar 2016 22:09:19 GMT

Maybe try

=sum({<MonthYear=,Month=,Section=,FileType=>}

aggr(sum({<SupplierName=,MonthYear=,Month=,Section=,FileType=>}AdjustedMeasure),Month,MonthYear,SupplierGroup,FileType,

Section,Description)
)

Re: Calculated Dimension in Set Analysis

Wed, 30 Mar 2016 22:18:36 GMT

Hi, thanks for the try but that doesn't work either...

Re: Calculated Dimension in Set Analysis

sunny_talwar — Wed, 30 Mar 2016 22:46:56 GMT

Why don't you create a new field in the script using your if statement and then use the new field for filtering? and then you ignore the selection in the new field.

Re: Calculated Dimension in Set Analysis

Wed, 30 Mar 2016 23:49:45 GMT

Hi, yes that is an option but I'm trying to avoid making any changes to the script at this stage as its pretty much finalised, also to be honest I'm trying to understand a bit more about calculated dimensions and see how this can be done in set analysis as I'm sure it won't be the first time I will come across this issue.

Any suggestions appreciated!

Re: Calculated Dimension in Set Analysis

sunny_talwar — Thu, 31 Mar 2016 08:54:13 GMT

Is this the chart dimension or is this a list box expression?

If this the chart dimension may be this:

If(Only({<Section>} FileType) = '$(vR4_IntSwitch)',

If(Left(Only({<Section>} Section), 1) = 'B', 'ELECTRICITY'), Null())

Re: Calculated Dimension in Set Analysis

swuehl — Thu, 31 Mar 2016 10:10:18 GMT

It would be easier to help if we get to know your setting a little better.

Could you upload a small sample QVW?