topic Re: Replacement IF condition by set analysis in QlikView

Replacement IF condition by set analysis

stantrolav — Mon, 26 Jan 2026 16:26:21 GMT

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.

Re: Replacement IF condition by set analysis

Gysbert_Wassenaar — Wed, 16 Oct 2013 16:06:01 GMT

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.

Re: Replacement IF condition by set analysis

christian77 — Wed, 16 Oct 2013 16:30:41 GMT

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.

Re: Replacement IF condition by set analysis

stantrolav — Thu, 17 Oct 2013 13:27:06 GMT

Thanks, G.