topic Re: Table row counter in separate chart in QlikView

Table row counter in separate chart

qv_bazz_10 — Thu, 25 Feb 2016 08:30:10 GMT

Hi guys,

i'm trying to add a row counter chart to a sheet and i'd like it to show the number of rows displayed in a certain table even without any selections. I know i can find that count in the right lower corner of the screen selecting a table but i'd like to have the counter always clearly visible.

N.B. I can't work on the scritp and i can't upload the file because i'm using a shared document.

Thanks in advance,

Andrea

Re: Table row counter in separate chart

Thu, 25 Feb 2016 11:02:47 GMT

You could add one expression such as Count(TOTAL ........) where .......... stands for your field

Hope this is what u need.

Re: Table row counter in separate chart

qv_bazz_10 — Thu, 25 Feb 2016 11:44:19 GMT

Hi Francesca,

tell me if what i did was what you mean. I have a sheet with many tables and the one i need to be counted with no selections has 105.652 rows with 2 dimensions (labeled as "ID Sede" and "Data Competenza") and some expressions. The dimension i need to count is "ID Sede" witch is univocal, so i created the expression below in the separate chart:

Count(TOTAL 'ID SEDE')

The result is always 1, maybe because it's not related to the specific dimension of the table or maybe because i did something wrong.

Here is a screenshot of a part of the sheet, the table i need to be counted is C.30 and the chart is on the right:

Thanks a lot for you help,

Andrea

Re: Table row counter in separate chart

Thu, 25 Feb 2016 13:18:37 GMT

I'm not sure I got what you need, you'd like to have the total number of Sedi in the table or in another object such as a Text object?

By the way Count(TOTAL 'ID SEDE') will give 1 because of '' ,

try with Count(TOTAL ID SEDE)

Hope it helps

Francesca

Re: Table row counter in separate chart

qv_bazz_10 — Thu, 25 Feb 2016 13:25:27 GMT

Quote from the other thread which has been duplicated.

by Marcus Sommer 25-feb-2016 13.17 (https://community.qlik.com/message/983016?et=watches.email.thread#983016)

You could use count-functions within a table-chart without dimensions like:

count(Dim1&Dim2&Dim3)

you will need to include your used dimensions.

But if you not want to count the number of records from certain charts (which is depending from the used dimensions) else you want to know how many records your tables have then you could use an inbuilt qv object "structure table" (last object by right click in sheet and choosing new object).

- Marcus

Re: Table row counter in separate chart

Digvijay_Singh — Thu, 25 Feb 2016 13:31:37 GMT

Its happening may be due to single apostrophe you have used in field name - Count(TOTAL 'ID SEDE')

Use Count(TOTAL [ID SEDE]) and it should work.

Re: Table row counter in separate chart

qv_bazz_10 — Thu, 25 Feb 2016 16:02:07 GMT

Hi Singh,

i inserted your function Count(TOTAL [ID SEDE]) in the definition box of the expression in the chart but the result is always "0".

Did i do something wrong?

Thanks,

Andrea

Re: Table row counter in separate chart

Digvijay_Singh — Thu, 25 Feb 2016 17:31:29 GMT

See the sample QVW, the red error in ur image could be due to spell typo in your field name. Not sure though.

Re: Table row counter in separate chart

Thu, 25 Feb 2016 20:14:01 GMT

It seems that your field name is not

ID SEDE but

IDSede (from the table you uploaded on your second post).

Check the correct field name in your script/table.

Regards

Francesca

Re: Table row counter in separate chart

qv_bazz_10 — Fri, 26 Feb 2016 08:27:44 GMT

Got it! Thank you Singh and thanks Francesca too!

Have a nice day,

Andrea