Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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

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.