
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Qlik Sense Record Count in table
I have a QS sheet in which they have displayed a Record Count.
That record count is count of latest version of data. So it says COUNT of version_ID for data source = Company A.
That record count is 700 and is displayed in form of KPI.
Now there is a table on the sheet and that has dynamic selection of dimensions. Users will choose which dimension they want to display on the table a=
The table will update based on dynamic selection of dimensions and other filters. After the selection, the row count is 300 .
I want the record count KPI to show as 300. This should dynamically update based on further selections
- Tags:
- qlik


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
how exactly are you counting the records?
it should be like = count(distinct rowid)
Where rowid is a field that identifies each row uniquely
If a post helps to resolve your issue, please accept it as a Solution.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thats the issue to identify the unique rows . When they select the combination of dimensions dynamically, the rowid (a field that identifies each row uniquely) changes. That unique field will depend on what dimensions they select.
