Discussion Board for collaboration related to QlikView App Development.
I have a table with dimension1 and dimension2
How to not load all rows where dimension2 is empty.
Because the result is:
The correct way would be:
Other rows without dimension 2 don't need to show up in the table.
Not working properly.
Still see row 1 and 3.
Try this below method:
Would you like to paste your code here, because I can't open qvw file.
suppose if you want to create straight table.
You have to enable the option suppress when value is null for both the dimensions.
Please see the image i have enable the option in presentation tab.
For Table Box,
Omit Values Where Field is Null
you got the answer?
It's chart table.
Presentation tab don't have this option.
For chart table,while adding dimensions you have to enable the option named Suppress When Value Is Null.
Note: Enable that option for both the dimensions.