topic Re: problem Aggr count in QlikView

problem Aggr count

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

hi everybody

When I want to aggreger this table by Month, I have no result

$(Vday) = 19 (It is a varialbe that I enter)

thanks

sunny_talwar — Tue, 14 Mar 2017 09:42:16 GMT

May be try this

Sum(Aggr(if(Date_Connexion>=date(DateFinMois-$(Vday)+1),1,0), Mois, Contrat, Date_Connexion))

Anonymous — Tue, 14 Mar 2017 09:56:34 GMT

no brother It does not work, I want to count the number of contracts per month

Sum(Aggr(if(Date_Connexion>=date(DateFinMois-$(Vday)+1),count(distinct Contrat),0), Mois, Contrat, Date_Connexion))

You can choose vday = 20

i must have 2 contrat in Mars = 1001,1000

sunny_talwar — Tue, 14 Mar 2017 10:00:08 GMT

May be this:

Count(DISTINCT Aggr(if(Date_Connexion>=date(DateFinMois-$(Vday)+1),Contrat), Mois, Contrat, Date_Connexion))

Anonymous — Tue, 14 Mar 2017 11:10:59 GMT

Thank you brother it worked, can i use it in a set analysis ?

sunny_talwar — Tue, 14 Mar 2017 11:14:32 GMT

You might have to make modifications in the script to make it work using set analysis (I am not 100% sure it will work though)

Anonymous — Tue, 14 Mar 2017 11:20:09 GMT

Thank you brother