
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Counting displayed table rows
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.
- « Previous Replies
-
- 1
- 2
- Next Replies »
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Here is the complete script and the expression:
Tbl1:
Load * Inline [
ID
1
2
3
4
];
Tbl2:
Load * Inline [
ID,Type
1,A
1,A
2,B
3,C
3,C
3,C
4,D
4,D
4,D
4,D
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...

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Can you share some sample for this.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Is this what you are looking for ?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
See smale example for this

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I am using qlik sense, in the example you sent what is 5 representing? is this the count of rows of another table?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Yes, the 5 is representing the count of rows of another table...

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
can you please send me the expression that you used.
Thank you.

- « Previous Replies
-
- 1
- 2
- Next Replies »