topic Re: Logic help for calculation =count(Date) in list box in QlikView

Logic help for calculation =count(Date) in list box

amit_saini — Tue, 15 Dec 2015 11:17:28 GMT

Hi Folks,

Not sure if this is possible.

I'm having simple script like below:

LOAD User,

Date,

month(Date) as Month,

year(Date) as Year

FROM

....

I have created below table in front end:

Is there any possibility that I can call count(Month) in a list box to get these numbers as a list????

Thanks,

Re: Logic help for calculation =count(Date) in list box

sunny_talwar — Tue, 15 Dec 2015 11:20:24 GMT

Try this:

=Aggr(Count(Month), Firstname, LastName)

Re: Logic help for calculation =count(Date) in list box

MayilVahanan — Tue, 15 Dec 2015 11:25:17 GMT

May be try like this,

Add expression in the listbox

First Name

Exp: = Count(Month)

Add like

=Aggr(Count(Month), [First Name])

Re: Logic help for calculation =count(Date) in list box

amit_saini — Tue, 15 Dec 2015 11:25:44 GMT

Sorry Sunny , it's showing me '-'

I have tried something like below:

=aggr(count( Date),Lastname)

and this is working , but i believe this is count of Date not Month

Thanks,
AS

Re: Logic help for calculation =count(Date) in list box

Anonymous — Tue, 15 Dec 2015 11:26:58 GMT

Yeah, you can......

Just use aggr() function in listbox expression intead of field....

Something like suggested by Sunny T

Re: Logic help for calculation =count(Date) in list box

amit_saini — Tue, 15 Dec 2015 11:32:24 GMT

I have already tried this , not working.

PFA

Thanks,
AS

Re: Logic help for calculation =count(Date) in list box

Anonymous — Tue, 15 Dec 2015 11:34:40 GMT

check this?

Re: Logic help for calculation =count(Date) in list box

amit_saini — Tue, 15 Dec 2015 11:42:12 GMT

Balraj,

Actually I'm facing issue below:

Some cases it is working fine like below

and

in some cases not like below:

Re: Logic help for calculation =count(Date) in list box

MayilVahanan — Tue, 15 Dec 2015 11:43:03 GMT

Hi'

Try like this

=(Aggr(Count(Month), User))

Re: Logic help for calculation =count(Date) in list box

amit_saini — Tue, 15 Dec 2015 11:44:42 GMT

I think I got it. This is working

=Aggr(Count(Month), User)

Thanks,

Re: Logic help for calculation =count(Date) in list box

Anonymous — Tue, 15 Dec 2015 11:48:01 GMT

try to aggr() with USER dim...