Number of rows in a table

[souadouert]

I want to display the row number of the array, the column "nb" is the primary key,

So I did a COUNT (nb), in the case I add the nb column to the array, the result is correct if I delete the column the tablau is incorrect

first with nb column :

second without

the script :

LOAD

     RowNo() as nb,

     MOIS,

     ANNEE,

     STAUT_CLIENT,

     MARCHE,

     DESCRIPTION_MARCHE_CLIENT,

     AGE_RELATION,

     DESCRIPTION_CATEGORIE_CLIENT,

     %ID_CATEGORIE_CLIENT,

     SEGMENT,

     CONQUETE,

     ANCIENNETE_RELATION,

     STATUT_AVA,

     PROD_AVA,

     %ID_AGENCE_CTOS_CLIENT,

     SOUS_MARCHE,

     SEGMENT_2015,

     TYPE_SOUS_MARCHE,

     NOMBRE_AVA

FROM

C:\pfe\DONNEES_RECAP\AVA.qvd

(qvd);

[PrashantSangle]

Hi,

Can you explain little bit more in details??

Regards,

[souadouert]

for agence= a3 i have 3 records , but the table display one row, and if i add the nb colomun  , the table display the 3 rows

[Anonymous]

try

=count(aggr(count(1), %ID_CATEGORIE_CLIENT, DESCRIPTION_CATEGORIE_CLIENT,N OMBRE_AVA))

[souadouert]

THE PROBLEM IN THE TABLE AND NOT THE COUNT

[PrashantSangle]

Hi,

this is because qlikview show number of distinct records w.r.t columns.

When you add nb column in table box then it will show 4 records because it have 4 distinct rows

similarly if you remove Nomber_Ava field from table box then it will give only 1 rows in table box

Regards,

[Anonymous]

=count(aggr(count(1), %ID_CATEGORIE_CLIENT, DESCRIPTION_CATEGORIE_CLIENT))

for the second table...

Continue to change the aggr each time the dimension changes...

[Peter_Cammaert]

A table box is a set of grouped listboxes that displays all possible combinations of listbox values. You can simulate a count of the number of values in those listboxes by using an expression like:

=count(DISTINCT %ID_CATEGORIE_CLIENT, & DESCRIPTION_CATEGORIE_CLIENT & NOMBRE_AVA)

This expression should follow all other selections, as the table box cannot be made to filter out anything (no set analysis, no expressions, no nothing) except by making selections.

[sunny_talwar]

Table box always shows the unique combination of the fields added to the table.... If you exclude nb (which is your unqiue identifier) you are only seeing the unique rows. Why do you not want to add nb in there?

[Peter_Cammaert]

I think you still misunderstand the way a Table Box operates. A Table Box is not a table, it's just a combination of listboxes, and listboxes show every distinct value only once !

The same happens with combinations of listboxes. Every uniqe combination is shown only once, whatever the gigantic table is that contains the base rows.