Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Highlighted
v_ganchev
New 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
Highlighted
Partner
Partner

Re: Two dimension

Hi Veselin,


Try Untitled.png

Highlighted
v_ganchev
New Contributor II

Re: Two dimension

Not working properly.
Still see row 1 and 3.

Highlighted
thannila
Contributor

Re: Two dimension

Try this below method:

Highlighted
v_ganchev
New Contributor II

Re: Two dimension

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

Highlighted
thannila
Contributor

Re: Two dimension

suppose if you want to create straight table.

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

Highlighted
thannila
Contributor

Re: Two dimension

Hi,

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

For Table Box,

               Omit Values Where Field is Null

thannila
Contributor

Re: Two dimension

you got the answer?

Highlighted
v_ganchev
New Contributor II

Re: Two dimension

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

Highlighted
thannila
Contributor

Re: Two dimension

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.