Problem with Syntax Set Analysis

Fri, 27 Aug 2010 13:24:56 GMT

Hi there,

I have a great problem with Set Analysis.

I want to change my IF-Statements toSet Analysis expressions (I have a lot of if-statements and I have problems with the performance)

Can somebody help me to change following expression:

sum(if(RechnungsWJdatumJJ = varWVGJ and Rechnungsdatum <= addmonths(vHEUTE -1, -12) and _keyArtGruppen = '1' and BonusArtikel = 'N' and SatzKZ = varArtikeleinheit, Rechnungswert)),

My problem is that the chapter "Rechnungsdatum <= addmonths(vHEUTE -1, -12) " (comparsion YTD)

I hope, the community can help me

Thank's a lot

Klaus

Problem with Syntax Set Analysis

Fri, 27 Aug 2010 15:19:11 GMT

If any of your chart dimension fields are part of IF conditions, then it's not possible to replace the IF condition by SET Analysis, because SET analysis works for whole chart, not individually for each chart row.

topic Problem with Syntax Set Analysis in QlikView

Problem with Syntax Set Analysis

Hi there,

I have a great problem with Set Analysis.

I want to change my IF-Statements toSet Analysis expressions (I have a lot of if-statements and I have problems with the performance)

Can somebody help me to change following expression:

sum(if(RechnungsWJdatumJJ = varWVGJ and Rechnungsdatum <= addmonths(vHEUTE -1, -12) and _keyArtGruppen = '1' and BonusArtikel = 'N' and SatzKZ = varArtikeleinheit, Rechnungswert)),

My problem is that the chapter "Rechnungsdatum <= addmonths(vHEUTE -1, -12) " (comparsion YTD)

Problem with Syntax Set Analysis