Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
adrianbuzer
Creator II
Creator II

Show even if no records


Hi

In a straight table how can I get it show all records within a dimension even if there are no records under a certain selection.  For example my dimension is Products and in a certain week one of the products was not sold but I still want it to show in the table.

Thanks

1 Solution

Accepted Solutions
rachael_selman
Partner - Contributor II
Partner - Contributor II

Try adding an additional expression to the straight table with set analysis to evaluate all sales (e.g. sum( {1} Sales)) then hiding the column (option in presentation tab).

View solution in original post

2 Replies
rachael_selman
Partner - Contributor II
Partner - Contributor II

Try adding an additional expression to the straight table with set analysis to evaluate all sales (e.g. sum( {1} Sales)) then hiding the column (option in presentation tab).

adrianbuzer
Creator II
Creator II
Author

Thank you Rachael