Solved: Re: Counting displayed table rows - Qlik Community

Anonymous · ‎2017-09-08

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.

trdandamudi · ‎2017-09-08

Here is the complete script and the expression:

Tbl1:

Load * Inline [

ID

1

2

3

4

];

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...

View solution in original post

its_anandrjs · ‎2017-09-08

Can you share some sample for this.

Anonymous · ‎2017-09-08

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

1

2

3

4

tbl2

A

B

C

D

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.

trdandamudi · ‎2017-09-08

Is this what you are looking for ?

its_anandrjs · ‎2017-09-08

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

its_anandrjs · ‎2017-09-08

See smale example for this

Anonymous · ‎2017-09-08

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.

Anonymous · ‎2017-09-08

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

trdandamudi · ‎2017-09-08

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

Anonymous · ‎2017-09-08

can you please send me the expression that you used.

Thank you.