topic Re: show total Rows number in chart in Qlik Automate

show total Rows number in chart

jack — Sat, 30 Dec 2023 21:37:42 GMT

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 — Sat, 30 Dec 2023 22:45:32 GMT

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

anat — Sun, 31 Dec 2023 03:51:26 GMT

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

jack — Sun, 31 Dec 2023 06:45:09 GMT

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 — Sun, 31 Dec 2023 06:46:30 GMT

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 — Fri, 05 Jan 2024 19:49:19 GMT

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