Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
v_ganchev
Contributor II
Contributor II

Two dimension

Hello.
I have a table with dimension1 and dimension2

How to not load all rows where dimension2 is empty.

Because the result is:

Dimension1Dimension2Expression
Dimension11
Dimension1Dimension22
Dimension13

The correct way would be:

Dimension1Dimension2Expression
Dimension1Dimension22

Other rows without dimension 2 don't need to show up in the table.

Thanks.

9 Replies
weijietc
Partner - Contributor III
Partner - Contributor III

Hi Veselin,


Try Untitled.png

v_ganchev
Contributor II
Contributor II
Author

Not working properly.
Still see row 1 and 3.

thannila
Creator
Creator

Try this below method:

v_ganchev
Contributor II
Contributor II
Author

Would you like to paste your code here, because I can't open qvw file.

thannila
Creator
Creator

suppose if you want to create straight table.

You have to enable the option suppress when value is null for both the dimensions.

thannila
Creator
Creator

Hi,

    Please see the image i have enable the option in presentation tab.

For Table Box,

               Omit Values Where Field is Null

thannila
Creator
Creator

you got the answer?

v_ganchev
Contributor II
Contributor II
Author

It's chart table.
Presentation tab don't have this option.

thannila
Creator
Creator

Hi,

             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.