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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
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!