Conditional hiding of Rows in table object - Urgent

[rajeshvaswani77]

Hi Community,

         I have a requirement related to the below table.

Policy	Reference
P1	V1
P1	-
P2	V2
P3	V3
P4	-
P5	V4

The requirement is that ALL Policies that have a Reference and also have a NULL reference then we have to show Only the one that has a Reference.

Example : P1 has reference V1,NULL then we will show the row only for V1

On the other hand if there is a Policy that has one or many null references(none of the reference here have a value)

Example : P4 , then we display this policy.

The output required is like below. How do we achieve this?

Policy	Reference
P1	V1
P2	V2
P3	V3
P4	-
P5	V4

Thanks in advance,

Rajesh Vaswani

[pat_agen]

hi,

try using maxstring(Reference) as your expression.

make sure tjhe option suppress zero-values is not ticked on the presentation tab.

[rajeshvaswani77]

Hi,

Thanks for the reply. If we use maxstring(Reference) then it will return only one value for that policy. But if i have more number of References for the same policy then i need to display all the references which are not null.

Also i am using table object here as we do not have any calculations.

Please suggest.

[rajeshvaswani77]

Hi,

     Further to the question I has asked. In a simplified way this is what is expected.

Policy	Reference	Policy Count	NULL Flag
P1	V1	2	0
P1	-	2	1
P2	V2	1	0
P3	V3	1	0
P4	-	1	1
P5	V4	1	0

When Policy Count is greater than 1 and NULL Flag is 1(Reference is NULL) then we need to hide that row. Could someone help with a way/expression to do this?

Thanks,

Rajesh Vaswani

[danielrozental]

What object are you using to display the table? simple table, pivot table or a table box?

If it's a table box you can just go to the presentation tab, select the reference field and select option "omit rows where field is null".

If you're using a chart then you can have either an if or a set analysis in the formula, something like if(not isnull(Reference),sum(value)) or sum({<Reference={*}>}value).