topic Re: Set Analysis in App Development

Set Analysis

arvindjha2050 — Wed, 22 Sep 2021 15:30:57 GMT

Hello all,

This is with regard to set analysis :

count({$<Country = {"sum({$<Week = {">$(=$(vTest))"}>}Sales) > 1000"}>}distinct Country)

The double quotes doesn't work inside the element set , with single quote output is not correct

Thiago_Justen_ — Wed, 22 Sep 2021 20:07:45 GMT

What about this?

count({$<Country = {"=sum({$<Week = {'>$(vTest)'}>}Sales) > 1000"}>}distinct Country)

arvindjha2050 — Thu, 23 Sep 2021 06:39:31 GMT

Hello ,

thanks for the reply but this option is already tried , it returns zero instead of correct output

tresB — Thu, 23 Sep 2021 07:08:30 GMT

Hi Arvind,

Single quotes wouldn't work for search strings. Instead try with back quote sign (grave accent) `, like:

count({$<Country = {"=sum({$<Week = {`>$(vTest)`}>}Sales) > 1000"}>}distinct Country)

arvindjha2050 — Thu, 23 Sep 2021 07:38:43 GMT

Thanks a lot Tresesco , it works