topic Re: Table row counter in a separate chart in QlikView

Table row counter in a separate chart

qv_bazz_10 — Thu, 25 Feb 2016 08:13:47 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 a separate chart

marcus_sommer — Thu, 25 Feb 2016 12:17:20 GMT

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 a separate chart

qv_bazz_10 — Thu, 25 Feb 2016 13:21:36 GMT

Hi Marcus,

i'm afraid the thread has been duplicated (Table row counter in separate chart), i'll quote and reply to your answer in the other one, this can be closed.

Thanks a lot,

Andrea

Re: Table row counter in a separate chart

Anonymous — Thu, 25 Feb 2016 13:31:26 GMT

Add this at script in table?

'1' as RecordCounter

then at UI: sum(RecordCounter)

Re: Table row counter in a separate chart

Anonymous — Thu, 25 Feb 2016 13:33:00 GMT

Also do not post same thread multiple times again and again

Table row counter in separate chart

Re: Table row counter in a separate chart

Colin-Albert — Thu, 25 Feb 2016 13:47:28 GMT

If you just want to see how many rows are in your tables then you can use the system fields $Table and $Rows in a chart. This row value will not change as you make selections.

You will need to tick the Show System Fields option.

Re: Table row counter in a separate chart

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

Unforunately I can't work on the script because it's a shared document. Sorry for the duplicated thread, this morning the connection was not very good.

Thanks,

Andrea

Re: Table row counter in a separate chart

qv_bazz_10 — Thu, 25 Feb 2016 16:32:18 GMT

Hi Albert,

i enabled system fields but i just can't understand how to make them work and i'm not sure that is really what i'm trying to do: what i need is a count of records (rows) contained in a table but it has to change every time i add any selection (and has to show the count without any selection too), so it has to be dynamic. Do you think i can do it with your previous advice?

Thanks a lot,

Andrea

Re: Table row counter in a separate chart

Colin-Albert — Thu, 25 Feb 2016 16:43:34 GMT

The $Rows figure shows the number of rows loaded on the last reload it does not change with user selections.

Add a straight table chart with $Table as the dimension and $Rows as the expression.

If you want the value to change as you make selections, the use a count(fieldname) expression in a chart where fieldname is a field unique to the table you wish to count.

count({1} fieldname) will show the count excluding all selections

Re: Table row counter in a separate chart

qv_bazz_10 — Fri, 26 Feb 2016 08:31:50 GMT

I got the answer here Table row counter in separate chart

Thank you all for the help,

Andrea

PS: if there's a somebody who can close and set the thread as solved i'd be thankful.

Re: Table row counter in a separate chart

Colin-Albert — Mon, 29 Feb 2016 09:31:25 GMT

Just flag up the correct answer and any helpful answers to close the thread.

Only the thread author (you) or a moderator can do this.