topic Re: skipping rows in graphic table in QlikView

skipping rows in graphic table

JACKNIEKERK — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: skipping rows in graphic table

kaushiknsolanki — Mon, 23 Dec 2019 05:07:59 GMT

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

Re: skipping rows in graphic table

JACKNIEKERK — Mon, 23 Dec 2019 10:39:57 GMT

thanks, regards Jack