topic Re: set analysis in QlikView

set analysis

Tue, 07 Jun 2016 09:50:53 GMT

Hi,

I am trying to optimize a calculation because it is not always calculating correctly.

I Need to Change it into a set Analysis calculation but I dont get it to work.

sum((if (xrefNr like '6*' and linetype=158 and linetype='158' and xref_GRPCODE='2KRE' and not (doccode like 'Z*' or doccode like 'BANK*' or doccode like 'A*'),Buchungsbetrag,0)))

Does somebody have an idea how the set Analysis must look like?

Very much thanks in advance.

Chris

Re: set analysis

swuehl — Tue, 07 Jun 2016 09:55:02 GMT

Try maybe something like

Sum(

{<xrefNr = {"6*"}, linetype = {158}, xref_GRPCODE = {'2KRE'}, docode -= {"(Z*|BANK*|A*)"}>}

Buchungsbetrag)

Re: set analysis

sunny_talwar — Tue, 07 Jun 2016 09:55:19 GMT

May be this:

Sum({<xrefNr = {'6*'}, linetype = {158}, xref_GRPCODE = {'2KRE'}, doccode -= {'Z*', 'BANK*', 'A*'}>} Buchungsbetrag)

Re: set analysis

Kushal_Chawda — Tue, 07 Jun 2016 09:59:39 GMT

Hi Stefan,

what is difference between docode -= {"(Z*|BANK*|A*)"} & doccode -= {'Z*', 'BANK*', 'A*'} ?

Re: set analysis

Tue, 07 Jun 2016 10:15:15 GMT

Thank you very much to all of you.

All Solutions worked 🙂

Re: set analysis

swuehl — Tue, 07 Jun 2016 10:15:32 GMT

Besides that I misspelled doccode?

I've used a single field modifier list element, a compound search including three searches, instead of three set modifier list elements that each contain a search, but I don't think that makes a big difference.

Mine is shorter

Re: set analysis

sunny_talwar — Tue, 07 Jun 2016 10:17:16 GMT

shorter by the count of characters?

Re: set analysis

Kushal_Chawda — Tue, 07 Jun 2016 10:17:53 GMT

Yes, that's what I wanted to know with regards to performance. Thanks