Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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);
i know that !! So any solution ?! to hid the colmun NB
good morning Sunny
i want to hid NB column Sunny
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.
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
i know that peter for taht i want to find solution to hid nb and display the all rows for a selection thnk y
Use straight table instead of table box take expresssion count(nb) and hide it in presentation tab.
Regards
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
Or add a dummy expression (like =1 ) and hide it as well...
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).
thank you sunny always with y i find good practices and correct solutions