Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
MS90
Creator
Creator

How to get No of rows count in Straight table dynamically

Need to show Total no of rows(how many records are present) in straight table dynamically when selecting the data

Labels (4)
1 Solution

Accepted Solutions
MayilVahanan

HI

Try like below

Count(Aggr(urexpression, dimensions))

ex: Count(Aggr(Sum(Total_sales), Name2))

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

3 Replies
dineshm030
Creator III
Creator III

Hi,

In the straight table, we have the option to show the no of total count rows. Below is the screenshot for your reference.

dineshm030_0-1680578595491.png

 

MS90
Creator
Creator
Author

In QlikSense at title in appearance tab it is required dynamically or there is any option to get us based on rowno

MayilVahanan

HI

Try like below

Count(Aggr(urexpression, dimensions))

ex: Count(Aggr(Sum(Total_sales), Name2))

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.