Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
zet
Contributor III
Contributor III

Count Total group by

Hello,

I have this table 

TypeSourceNbPositions
DBREHAT2122
DSiriusNG8
D-1
ABREHAT2124
A-5
PBREHAT2125
PSiriusNG6
P-1

 

I'm using this expression to calculate NbPositions: count(Aggr(count(Source),Date_Circulation,Numero_Sillon,CR_CI_CH,Type_Horaire,Source))

and I want to add new column using new expression to count total by type like this :

TypeSourceNbPositionsTotal By Type
DBREHAT212211
DSiriusNG811
D-111
ABREHAT21249
A-59
PBREHAT212512
PSiriusNG612
P-112

 

Thanks in advance.

Labels (4)
1 Solution

Accepted Solutions
Kushal_Chawda

@zet  try below

count(total <Type> Aggr(count(Source),Date_Circulation,Numero_Sillon,CR_CI_CH,Type_Horaire,Source))

View solution in original post

2 Replies
Kushal_Chawda

@zet  try below

count(total <Type> Aggr(count(Source),Date_Circulation,Numero_Sillon,CR_CI_CH,Type_Horaire,Source))

View solution in original post

zet
Contributor III
Contributor III
Author

Thanks a lot !