Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
ashmitp869
Creator II
Creator II

Null showing at end when using rowno(total) in measure expression

Hi All,

Why am i getting this null at the end -

I have added the #Rows count - rowno(total) expression 

ashmitp869_0-1647568727496.png

 

1 Solution

Accepted Solutions
abhijitnalekar
Specialist II
Specialist II

Hi @ashmitp869 ,

you can uncheck the checkbox of including null values to remove null from the table.

Please go through with the below link 

https://community.qlik.com/t5/QlikView-App-Dev/How-to-Exclude-Null-Value-from-Count/td-p/1081605

Regards,
Abhijit
keep Qliking...
Help users find answers! Don't forget to mark a solution that worked for you!

View solution in original post

1 Reply
abhijitnalekar
Specialist II
Specialist II

Hi @ashmitp869 ,

you can uncheck the checkbox of including null values to remove null from the table.

Please go through with the below link 

https://community.qlik.com/t5/QlikView-App-Dev/How-to-Exclude-Null-Value-from-Count/td-p/1081605

Regards,
Abhijit
keep Qliking...
Help users find answers! Don't forget to mark a solution that worked for you!