Two dimension

[v_ganchev]

Hello.
I have a table with dimension1 and dimension2

How to not load all rows where dimension2 is empty.

Because the result is:

Dimension1	Dimension2	Expression
Dimension1		1
Dimension1	Dimension2	2
Dimension1		3

The correct way would be:

Dimension1	Dimension2	Expression
Dimension1	Dimension2	2

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

Thanks.

[weijietc]

Hi Veselin,

Try

[v_ganchev]

Not working properly.
Still see row 1 and 3.

[thannila]

Try this below method:

[v_ganchev]

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

[thannila]

suppose if you want to create straight table.

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

[thannila]

Hi,

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

For Table Box,

               Omit Values Where Field is Null

[thannila]

you got the answer?

[v_ganchev]

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

[thannila]

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.