skipping rows in graphic table

[JACKNIEKERK]

in qlikview how to create a statement if in a grafic table one off the fields is empty to skip the row in displaying
in this attached sample filed 'klantcode' is empty so i dont want to see that row

[kaushiknsolanki · Accepted solution]

Hi,

If its a Dimension, then go do followings.

1.Go to Properties

2. Dimensions

3. Select the Dimension (For which you want to remove the row)

4. Select  "Suppress when value is Null".

5. Click Apply

If its a expression, then do followings.

1. Go to Properties

2. Go to Presentation Tab

3. Check the options

"Suppress Missing"

4. Click Apply.

Regards,

Kaushik Solanki

[JACKNIEKERK]

thanks, regards Jack