topic Re: Straight table- show when value is zero in QlikView

Straight table- show when value is zero

robert_mika — Wed, 02 Mar 2016 02:10:14 GMT

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?

Re: Straight table- show when value is zero

tamilarasu — Wed, 02 Mar 2016 02:19:53 GMT

Could you attach your file (or sample).?

Re: Straight table- show when value is zero

robert_mika — Wed, 02 Mar 2016 02:22:46 GMT

Sorry is confidential.

Re: Straight table- show when value is zero

sunny_talwar — Wed, 02 Mar 2016 02:23:20 GMT

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

Re: Straight table- show when value is zero

Anonymous — Wed, 02 Mar 2016 05:23:07 GMT

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)

Re: Straight table- show when value is zero

its_anandrjs — Wed, 02 Mar 2016 05:47:59 GMT

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

Re: Straight table- show when value is zero

vikasmahajan — Wed, 02 Mar 2016 06:12:08 GMT

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

HTH

Vikas