Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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.