topic Re: Counting displayed table rows in QlikView

Counting displayed table rows

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have 2 tables when I select from the fist one the second table is updated, can anyone please tell me how to count the rows in the second table? getselectedcount is not working because selection is done from the fist table.

Thank you.

Re: Counting displayed table rows

its_anandrjs — Fri, 08 Sep 2017 16:36:51 GMT

Can you share some sample for this.

Re: Counting displayed table rows

Anonymous — Fri, 08 Sep 2017 18:16:04 GMT

I have a table that has some information selected from database and I have another table that display more information when a selection is made from the first table, now what I want to do is to count the number of records displayed in the second table

for example I have table tbl1 and tbl2

tbl1

tbl2

So when I select 1 for example form the first table the second table will display the records depending on the relation between the 2 tables, I want to know how to count the number of records displayed in tbl2. I tried to use getselectedcount but it does not work because there is not selection happened on tbl2.

I hope this made it more clear.

Thank you.

Re: Counting displayed table rows

trdandamudi — Fri, 08 Sep 2017 18:28:38 GMT

Is this what you are looking for ?

Re: Counting displayed table rows

its_anandrjs — Fri, 08 Sep 2017 18:34:07 GMT

Obviously it is due to the Qlikview Associative properties due that it is happen why you count that value you can view it on the UI part that how may records get selected. You can use property Show Frequency in list object of another table and it visible to you on each record.

Hope this make sense

Re: Counting displayed table rows

its_anandrjs — Fri, 08 Sep 2017 18:38:19 GMT

See smale example for this

Re: Counting displayed table rows

Anonymous — Fri, 08 Sep 2017 19:05:11 GMT

I am using qlik sense and I want to display the count in KPI, I can't open the example it is not showing any data.

Re: Counting displayed table rows

Anonymous — Fri, 08 Sep 2017 19:07:47 GMT

I am using qlik sense, in the example you sent what is 5 representing? is this the count of rows of another table?

Re: Counting displayed table rows

trdandamudi — Fri, 08 Sep 2017 20:17:42 GMT

Yes, the 5 is representing the count of rows of another table...

Re: Counting displayed table rows

Anonymous — Fri, 08 Sep 2017 21:14:18 GMT

can you please send me the expression that you used.

Thank you.

Re: Counting displayed table rows

trdandamudi — Sat, 09 Sep 2017 00:27:15 GMT

Here is the complete script and the expression:

Tbl1:

Load * Inline [

];

Tbl2:

Load * Inline [

ID,Type

1,A

2,B

3,C

4,D

];

Expression:

=If(GetSelectedCount(ID)=0,'',Count(Type))

Note: If nothing is selected then it will not show any count and that is the reason I am using IF condition.

Hope this helps...

Re: Counting displayed table rows

Anonymous — Mon, 11 Sep 2017 16:12:28 GMT

Thanks a lot that was so helpful.

Re: Counting displayed table rows

trdandamudi — Mon, 11 Sep 2017 19:10:53 GMT

You are welcome and happy to hear that it is helpful for you..