topic Re: How to supress rows in table depending on expression value in QlikView

How to supress rows in table depending on expression value

Tue, 31 Mar 2015 08:43:23 GMT

Good morning, I have this expression:

(Sum(If(FVWFD_TIPOL_AGEVOL='F',[IMPORTO FINANZIAMENTO RICHIESTO],IF(FVWFD_TIPOL_AGEVOL='C',

[IMPORTO CONTRIBUTO RICHIESTO],IF(FVWFD_TIPOL_AGEVOL='G', [IMPORTO GARANZIA RICHIESTO]))))) /100

I would supress the row where this expression is equal to 0.

Thanks to all

Giovanni

Re: How to supress rows in table depending on expression value

Tue, 31 Mar 2015 08:55:56 GMT

in which chart do you want to represent it..in most cases it will suppress automatically zero values, go to presentation chart and you will find suppress zero values check box.

or if you dont want to show zero values, write an if condition on you expr to show only greater than zero values

ex: if(expression >0, expression)

regards

amay

Re: How to supress rows in table depending on expression value

Tue, 31 Mar 2015 08:58:48 GMT

Hi,

You can check the suppress when value is null in Dimension tab and presentation tab.

Re: How to supress rows in table depending on expression value

jagan — Tue, 31 Mar 2015 09:10:31 GMT

Hi,

Try like this

If((Sum(If(FVWFD_TIPOL_AGEVOL='F',[IMPORTO FINANZIAMENTO RICHIESTO],IF(FVWFD_TIPOL_AGEVOL='C',

[IMPORTO CONTRIBUTO RICHIESTO],IF(FVWFD_TIPOL_AGEVOL='G', [IMPORTO GARANZIA RICHIESTO]))))) /100 = 0, Null(),

(Sum(If(FVWFD_TIPOL_AGEVOL='F',[IMPORTO FINANZIAMENTO RICHIESTO],IF(FVWFD_TIPOL_AGEVOL='C',

[IMPORTO CONTRIBUTO RICHIESTO],IF(FVWFD_TIPOL_AGEVOL='G', [IMPORTO GARANZIA RICHIESTO]))))) /100)

If you have other expressions in the same chart then you have give the same expression in all the dimensions

If((Sum(If(FVWFD_TIPOL_AGEVOL='F',[IMPORTO FINANZIAMENTO RICHIESTO],IF(FVWFD_TIPOL_AGEVOL='C',

[IMPORTO CONTRIBUTO RICHIESTO],IF(FVWFD_TIPOL_AGEVOL='G', [IMPORTO GARANZIA RICHIESTO]))))) /100 = 0, Null(), 'Expression 2')

Regards,

Jagan.

Re: How to supress rows in table depending on expression value

Tue, 31 Mar 2015 09:12:28 GMT

Hi, the expression is not for a dimension, I can't check the suppress when value is null in dimension tab.

I represent the expression in a pivot table.

Thanks

Re: How to supress rows in table depending on expression value

Tue, 31 Mar 2015 09:14:48 GMT

Hi jagan, I would supress the row when the expression is null or equal to 0.

Regards

Giovanni

Re: How to supress rows in table depending on expression value

jagan — Tue, 31 Mar 2015 09:24:42 GMT

Hi,

The row will be supressed when all the expression values are zero in that row. If you have only one expression then you can directly use Suppress Zero values option in Presentation tab.

Hope this helps you.

Regards,

Jagan.

Re: How to supress rows in table depending on expression value

Tue, 31 Mar 2015 09:31:31 GMT

Hi, I have another 4 expression for the row ... It's impossible ?

Re: How to supress rows in table depending on expression value

jagan — Tue, 31 Mar 2015 09:39:16 GMT

Hi,

You can do that but you need to give the If in all the expressions, check my previous posts.

Regards,

Jagan.

Re: How to supress rows in table depending on expression value

Tue, 31 Mar 2015 09:43:42 GMT

Hi Jagan,

I put the if condition in all expression, but after how can I supress the row with null value for only this expression ?

Thanks

Giovanni