topic Re: Two dimension in QlikView

Two dimension

v_ganchev — Wed, 07 Nov 2018 06:48:56 GMT

Hello.
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:

Dimension1	Dimension2	Expression
Dimension1	Dimension2	2

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

Thanks.

weijietc — Wed, 07 Nov 2018 08:44:48 GMT

Hi Veselin,

Try

v_ganchev — Wed, 07 Nov 2018 09:27:15 GMT

Not working properly.
Still see row 1 and 3.

thannila — Wed, 07 Nov 2018 10:22:01 GMT

Try this below method:

v_ganchev — Wed, 07 Nov 2018 10:27:22 GMT

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

thannila — Wed, 07 Nov 2018 10:33:28 GMT

suppose if you want to create straight table.

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

thannila — Wed, 07 Nov 2018 10:36:08 GMT

Hi,

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

For Table Box,

Omit Values Where Field is Null

thannila — Wed, 07 Nov 2018 11:04:23 GMT

you got the answer?

v_ganchev — Thu, 08 Nov 2018 11:10:53 GMT

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

thannila — Thu, 08 Nov 2018 11:33:00 GMT

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.