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);

[souadouert]

i know that !! So any solution ?! to hid the colmun NB

[souadouert]

good morning Sunny

i want to hid NB column Sunny

[Peter_Cammaert]

No. Do NOT use a Table Box.

You can easily rebuild the same object using a regular straight table. Straight tables allow you to hide columns, like the NB column. When hidden, the NB column will still make sure that different NB values will produce different rows, althoug hthe visible part will be identical to other rows...

This will be very confusing for your QlikView users.

[sunny_talwar · Accepted solution]

May be use a straight table instead of table box and then you can add your 3 columns and nb as dimensions and on the presentation tab, do two things

1) uncheck 'Suppress Zero Values' and

2) Hide nb column from displaying

[souadouert]

i know that  peter for taht i want to find solution to hid nb and display the all rows for  a selection thnk y

[PrashantSangle]

Use straight table instead of table box take expresssion count(nb) and hide it in presentation tab.

Regards

[sunny_talwar]

Hey... good morning... may be use a straight table with only dimensions and no expression. Add your 3 columns and nb as dimensions and on the presentation tab, do two things

1) uncheck 'Suppress Zero Values' and

2) Hide nb column from displaying

[Peter_Cammaert]

Or add a dummy expression (like =1 ) and hide it as well...

[Peter_Cammaert]

There are few things in QlikView that you cannot change. One of them is the Table Box object. Mainly useful for debugging purposes (for example key values that don't match).

[souadouert]

thank you sunny always with y i find good practices and correct solutions