topic Using dimension values in set analysis in QlikView

Using dimension values in set analysis

Fri, 02 Mar 2012 22:56:07 GMT

Hi,

I have a static straight table that I would like to use the values from a dimension in my set analysis. The dimension that I would like to use in this example is [Year]. Is it possible for set analysis to work in this case?

Example: =SUM( {$<[Finance Year] = {'[Year]'} >} [Revenue])

Where: [Year] is directly from the master calendar, and [Finance Year] & [Revenue] are column names for another table.

Please note: I want to avoid setting [Finance Year] as a dimension.

Using dimension values in set analysis

phaneendra_kunc — Sat, 03 Mar 2012 07:04:44 GMT

Hi,

Dont know if i understood your problem correctly..

See if this helps.

1.) create a variable vYear = Concat(Year,',')

2.) use this variable in your expression. =SUM( {$<[Finance Year] = {'$(Year)'} >} [Revenue])

Regards,

Phani

Using dimension values in set analysis

CELAMBARASAN — Sat, 03 Mar 2012 08:31:58 GMT

Hi,

Try with this.

Sum(Aggr(If(Year=[Financial Year],Sum(Revenue)),[Financial Year]))

Celambarasan

Using dimension values in set analysis

Sat, 03 Mar 2012 10:37:33 GMT

Hi Sean,

I am not sure if I understand you clearly. But it sounds to me like you using expressions to obtain the columns [Financial Year] and [Revenue] in that other table. If that's the case why don't you to set them as variables?

Say:

vFinancialYear='Expression used in the other table' and

vRevenue= 'Expression used in the other table'.

You may them try to use something like:

SUM({$<Year={"$(vFinancialYear)"}>} $(vRevenue)) ?

Re: Using dimension values in set analysis

Wed, 27 Feb 2013 09:56:27 GMT

Hi Sean,

I have the same question, did you find a solution yet?

Thanks! Wouter