Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Partner
Partner

Hi Veselin,


Try Untitled.png

Highlighted
Contributor II
Contributor II

Not working properly.
Still see row 1 and 3.

Highlighted
Creator
Creator

Try this below method:

Highlighted
Contributor II
Contributor II

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

Highlighted
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.

Highlighted
Creator
Creator

Hi,

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

For Table Box,

               Omit Values Where Field is Null

Highlighted
Creator
Creator

you got the answer?

Highlighted
Contributor II
Contributor II

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

Highlighted
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.