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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
sersal10
Creator
Creator

How to show NULLs in a table

Hi all,

I have a table with 3 columns:

1- country,

2- a percentage tickets sold over the total tickets sold, and

3- number of tickets sold for that country.

There are many rows that are not fill in, and I want them to be displayed at the table. If I go to the edit option and choose the country field and select "include null values", they are added up tot the total of the 3rd column, but they are not added as a row in the table showing for instance "-" instead of the country. I saw that before but cannot find how to do it anymore.

Any help much appreciated.

 

Kind regards,

Sergio.

 

Labels (2)
1 Solution

Accepted Solutions
sersal10
Creator
Creator
Author

I solved it remaking the table from the beginning.

View solution in original post

1 Reply
sersal10
Creator
Creator
Author

I solved it remaking the table from the beginning.