topic Graph Issues in QlikView

Graph Issues

krishnacbe — Thu, 09 Aug 2012 12:22:15 GMT

I have a Line Chart. I have Dimension as Date & expression =Count(ID). I need to enable a condition like A='-1' then count(ID) should reflect it.

Actual result should be 9. after selecting only i am getting the data. I need to show only exceptions team -1. this condition should be given in expression.

Can any one help to fix this.

Regards

Krishna

Re: Graph Issues

swuehl — Thu, 09 Aug 2012 12:26:14 GMT

Try

=count(if(ExceptionsTeam = -1,ID))

Re: Graph Issues

krishnacbe — Thu, 09 Aug 2012 12:29:50 GMT

Hi swuehi

Thanks a lot it working fine.

Regards

Krishna.