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: 
Not applicable

How to display column for rownumber with the title being empty

In a straight table I’d like tohave the first column display a row number (line number). The problem is if the label is blank it displays the text from the expression, which i do not want.

The ugly solution is to leave the first line within the expression blank.

The row number can be displayed via "=RowNo()"

1 Solution

Accepted Solutions
Not applicable
Author

if you dont wan´t the space charakter try

=''      ( equal -  single quote - single quote    not   equal - double quote 😉     )

it calculate a empty string as label

View solution in original post

4 Replies
swuehl
MVP
MVP

Hi,

I don't know if this is any better that leaving the first line empty or if I completely got what you are after, but I think you could also use a space as label.

Regards,

Stefan

Not applicable
Author

thanks swuehl,

both are not perfect, but yours is still better.

Not applicable
Author

if you dont wan´t the space charakter try

=''      ( equal -  single quote - single quote    not   equal - double quote 😉     )

it calculate a empty string as label

Not applicable
Author

Thanks bauernschmitt!!!!

This is the least of the three evils

I’m using this solution with a minor enhancement for readability. I added spaces between the quotes. It now clearly indicates to the developer reading the code what your "real" intention is. It also eliminates the confusion of thinking that it’s a double quote.

='     '