topic Re: Counting Field - Typing Error in QlikView

Counting Field - Typing Error

nesonica — Sat, 16 Nov 2024 21:15:14 GMT

Hi guys,

this formula seems not to work and I do not find my error. I was trying to count those orders where there is only one order position. Can you help me? 🙂 Thanks in advance!

Count({<PeriodMath={'>=$(vMinPeriodYear2)<=$(vMaxPeriod2)'},Sum(Count(POSITIONNUMBER)={1})>}ORDERNUMBER)

Re: Counting Field - Typing Error

jaibau1993 — Wed, 13 Mar 2019 15:37:48 GMT

Hi!

In set analysis you have to write sets for fields in your data model. You can not use

Sum(Count(POSITIONNUMBER)={1}

because "Sum(Count(POSITIONNUMBER)" is not a field. You may use something like

Count({<PeriodMath={'>=$(vMinPeriodYear2)<=$(vMaxPeriod2)'}, ORDERNUMBER = {"=Count(POSITIONNUMBER) = 1"})>} ORDERNUMBER)

Hope it helps!

Jaime.

Re: Counting Field - Typing Error

nesonica — Wed, 13 Mar 2019 15:55:54 GMT

Thanks so much! 😄 That worked