Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
naishaansh
Contributor III
Contributor III

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

Labels (3)
2 Replies
vinieme12
Champion III
Champion III

how exactly are you counting the records?

it should be like =  count(distinct rowid)

 

Where rowid is a field that identifies each row uniquely

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
naishaansh
Contributor III
Contributor III
Author

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.