topic Re: Count with 2 parameters in a age structure in QlikView

Count with 2 parameters in a age structure

AlbanMONTBILLIARD — Fri, 18 Sep 2020 14:44:29 GMT

I tried to make an age structure (pyramide des ages in french) but i have more result in it than i want.

The expression than i use is

count({<SEX={"M"}>+<MONTH="202008">}SEX)

but the result contain all the men in all the month.

Where are my error ?

Thanks for you're help

edwin — Fri, 18 Sep 2020 15:21:50 GMT

try it with a comma:

count({<SEX={"M"}>,<MONTH="202008">}SEX)

Taoufiq_Zarra — Fri, 18 Sep 2020 15:26:20 GMT

avec le plus dans Set si la condition Sex=M est Ok donc pas besoin d'aller plus dans le Set analyisi (si la syntaxe est ok aussi)

si j'ai bien compris tu as besoin de :

count({<SEX={"M"}, MONTH={"202008"}> } SEX) , sinon est ce que tu peux partager un exemple de data avec ce que tu souhaite comme output ?

Kushal_Chawda — Fri, 18 Sep 2020 15:27:39 GMT

count({<SEX={"M"},MONTH={"202008"}>}SEX)

AlbanMONTBILLIARD — Fri, 18 Sep 2020 18:37:50 GMT

Thanks a lot. That's good

AlbanMONTBILLIARD — Fri, 18 Sep 2020 19:00:44 GMT

I try to extend the problem and remplace "202008" by max(month) but that not match. Why ?

sunny_talwar — Fri, 18 Sep 2020 19:47:40 GMT

Try this

Count({<SEX = {"M"}, MONTH = {"$(=Max(MONTH))"}>} SEX)

Taoufiq_Zarra — Fri, 18 Sep 2020 19:49:23 GMT

=count({<SEX={"M"}, MONTH={"$(=Max(MONTH))"}> } SEX)

AlbanMONTBILLIARD — Fri, 18 Sep 2020 20:06:04 GMT

Thanks a lot you two. You're the best