Straight table- show when value is zero

[robert_mika]

How to show entry for a row if the expression delivers 0:

Example:

My expression(after filtering)

count({< [Last Date]={">=$(=vStartDateD)<=$(=vEndDateD)"}>}[Oppor] )

delivers zero for one row

when using generic 1 i can show that value:

How to show that row using the expression?

[tamilarasu]

Could you attach your file (or sample).?

[robert_mika]

Sorry is confidential.

[sunny_talwar]

Can you explain with some dummy data what exactly you are trying to do?

[Anonymous]

go to the properties of the table and go the lay out tab  and give the condition is if(getselectionfield (column name='0') ,1,0)

[its_anandrjs]

Hi Robert,

In the dimensions select all dimensions one by one and select Show All Values and in the presentation tab unchecked option Supress Zero-Values and select Populate Missing Values fill zero over there.

Regards,

Anand

[vikasmahajan]

If you are using QV11 version in conditional you can give  count({< [Last Date]={">=$(=vStartDateD)<=$(=vEndDateD)"}>}[Oppor] ) > 0

HTH

Vikas