show total Rows number in chart

[jack]

have a simple chart with 2 colums,    a. custumnumber  , b. custumname , need on top chart to to show

the total off number off rows in that chart  in top off chart   or  a textbox  next to chart separate i need to show total of

rows in that chart

please advise

[jochem_zw]

Add an expression: count(custumnumber) it will add a column with a 1 for every row and a total for all rows

[anat · Accepted solution]

you can try by using 1 identifier in set analysis to show total number like count({1} custumnumber)

above expression you can use either in chart title or use separate text or button object

below the link for set analysis guide

https://help.qlik.com/en-US/qlikview/May2023/Subsystems/Client/Content/QV_QlikView/ChartFunctions/Se...

[jack]

Hello  , the problem is that count({1} custumnumber)   will give NOT what i need the total fysical rows in that chart

but since in the tabel with the customers has mutiple order lines

it will give total orderlines for the customers

 please look at screenshot   (partly in orignal Dutch text)

thanks for advice if solvable

best regards

[jack]

Hello  , the problem is that count(custumnumber)  also  will give NOT what i need the total fysical rows in that chart

but since in the tabel with the customers has mutiple order lines

it will give total orderlines for the customers

 please look at screenshot   (partly in orignal Dutch text)

thanks for advice if solvable

best regards

[jack]

Hello  , the problem is that count(custumnumber)  also  will give NOT what i need the total fysical rows in that chart

but since in the tabel with the customers has mutiple order lines

it will give total orderlines for the customers

 please look at screenshot   (partly in orignal Dutch text)

thanks for advice if solvable

best regards

[jack]

in that https link we found other syntax witch works ok in a separate object place next to chart on screen

and made it smal so only 1 row shows

sysntax    RowNo(TOTAL)-1