topic Re: num aggregation inside count in QlikView

num aggregation inside count

Mon, 26 Jan 2026 18:19:17 GMT

Hi everybody ,

i stuck for 2 days, i want to do a num aggregation inside a count but it didn't work

here is my expression

=count( {$ <4={" num(day(today())) "}> } [Nom Client])

thanks in advance.

Re: num aggregation inside count

Gysbert_Wassenaar — Tue, 04 Feb 2014 12:35:21 GMT

In a set analysis expression you must use a field name on the left side of the comparison. So if 4 is not a field name replace it with something that is. Something like: =count( {$ <MyDayNumber={"$(=num(day(today())))"}> } [Nom Client])

Re: num aggregation inside count

Peter_Cammaert — Tue, 04 Feb 2014 12:35:52 GMT

Change " num(day(today())) " into "$(=num(day(today()))) "

Best,

Peter

Re: num aggregation inside count

Tue, 04 Feb 2014 13:14:04 GMT

i tried both and it works but the result is not correct

what im trying to do is obtaining total commands of today for distinct clients

count( {$ <"$(=num(day(date(today()))))"="$(=num(day(date([Date CA]))))"> } distinct [Nom Client])

Re: num aggregation inside count

MK_QSL — Tue, 04 Feb 2014 13:27:44 GMT

What is Total Commands? Is it a field?

Re: num aggregation inside count

Tue, 04 Feb 2014 13:34:46 GMT

sorry i made a mistake , a client can get many commands but i want to get number of distinct clients for to day who has made commands , nom client and date ca are fields

thx

Re: num aggregation inside count

Peter_Cammaert — Tue, 04 Feb 2014 13:35:06 GMT

You should have an OrderNumber and an OrderDate somewhere. If I read your requirement correctly, the following should do:

=count({<OrderDate={"$(=today())"}>} distinct OrderNumber)

Change my fieldnames in yours. Then put this expression in a Straight table and add CustomerName as dimension.

Peter

Re: num aggregation inside count

Peter_Cammaert — Tue, 04 Feb 2014 13:38:38 GMT

How about this:

=count(aggr(count({<[Date CA]={"$(=today())"}>} OrderNumber), [Nom Client]))

Replace OrderNumber with the correct field name.

Peter

Re: num aggregation inside count

Peter_Cammaert — Tue, 04 Feb 2014 13:44:30 GMT

Or maybe even simpler?

=count({<[Date CA]={"$(=today())"}>} distinct [Nom Client])

Best,

Peter

Re: num aggregation inside count

Tue, 04 Feb 2014 13:48:04 GMT

it gives me the same result for day,month and total clients, so it not making selections

Re: num aggregation inside count

Tue, 04 Feb 2014 13:50:40 GMT

and dates are not integer

Re: num aggregation inside count

Peter_Cammaert — Tue, 04 Feb 2014 13:55:15 GMT

Indeed, it is just returning the total number of clients that made at least one order today. And today will only change after midnight. Every selection apart from those in field [Date CA] will influence the outcome of this expression.

If you want it to be tuned for a particular behavior, please post your requirements or submit an example document.

Peter

Re: num aggregation inside count

Tue, 04 Feb 2014 14:01:46 GMT

im very gratful mr peter for your time

here is another exemple whene im counting clients who hade made at least one commande in the current month

=count( {1 <"$(=num(month(today())))"="$(=num(month([Date CA])))"> } distinct [Nom Client])

but the problem it always give me the same result as the other expression

Re: Re: num aggregation inside count

Peter_Cammaert — Tue, 04 Feb 2014 14:21:44 GMT

THe left hand side of a Set Modifier has to be a field name. In your script, make sure that you have fields like [Date CA Mois] and [Date CA Année Mois] in addition to the base field [Date CA].

Imagine that the new field [Date CA Année Mois] contains values like '2014-02', then you can write an expression like this to obtain the correct count.

=count( {1 <[Date CA Année Mois]="$(=date(today(), 'YYYY-MM'))"> } distinct [Nom Client])

BTW for the first case I have a working example in attachment.

Good luck,

Peter

Re: num aggregation inside count

Tue, 04 Feb 2014 14:51:29 GMT

thank you very much peter