Replacement IF condition by set analysis

[stantrolav]

I got an expression with IF condition. It work's too slow. I want to change it to set analysis,

1. Expression with IF (it works fine):

sum(aggr( count (DISTINCT  if([Month] = [DistMonth],

  [CholdingID])),Fil, [MY],[CholdingID]))

2. My expression:

count(Aggr(sum(

{1<[Month] = {"=[Month]=[DistMonth]"}>}

1),Fil,[Month],[CholdingID]))

The main trouble is in marking multiply values in [DistMonth]. When i use first expression everything works fine. But with second expression I cant chose  multiply values. Second expression works with single value of [DistMonth] only. When i try to get two values of [DistMonth] it dont show me two values in dimension.

[Gysbert_Wassenaar · Accepted solution]

Set analysis calculates one set per chart, not per row. That means that comparing fields on the same row probably doesn't do what you expect. I've tried to explain what happens in this document: set_analysis_intra-record.qvw. I hope this helps.

[christian77]

Hi:

I understand that your problem is to set a variable with several months on it.

This is what I usually do:

Imagine I have selected 3 months Jan, Feb, Jun. To pick them up in a var,

vMonth   concat(distinct Month,’”’) work out the quotations and it is yours.

Then in your set analysis Month={$('vMonth)'}

I recomend you to use set analysis instead of ifs clauses.

Salutes.

[stantrolav]

Thanks, G.