topic total in QlikView

total

Thu, 31 Jul 2014 15:02:32 GMT

Hi all,

Can anyone know how to set the first Total column's value to zero?

And I also don't know why the Total column's value is '-'.

The expression as follow:

Please help to solve the problem.

Thanks too much

Going

Re: total

simenkg — Thu, 31 Jul 2014 15:06:41 GMT

There are many issues here, but the reason you get - in the total is because [Static Field1] has both Open and Close as possible values, and therefore calling the field without an aggregation function returns null().

Could you not simplify this whole expression to simply

Count({$<OB_Call_Flag={'Yes'}>}[OB Call Id])

Then you format the expression on the "Number"-tab of the charts properties box.

Re: total

SunilChauhan — Thu, 31 Jul 2014 15:11:01 GMT

try dimesionality()

if ( dimesionality()=0,0,expression)

if ( secondarydimesionality()=0,0,expression)

hope this helps

Re: total

Thu, 31 Jul 2014 15:24:11 GMT

Hi ,

Thanks for your reply.

But follow your advice, it also doesn't work.

Best regards,

Going

Re: total

SunilChauhan — Thu, 31 Jul 2014 15:27:25 GMT

presentation->Null symbol and missing symbol place 0 inplace of -

hope this helps

Re: total

Thu, 31 Jul 2014 15:41:18 GMT

Hi chauhans85,

Follow your advice, the Total column's value is zero.

But when the "no answer", "busy" ... columns have values(not zero), the Total column should show the sum number, not zero.

Hope you understand.

Re: total

simenkg — Thu, 31 Jul 2014 15:47:31 GMT

I suspect this is a combination of issues.

Replace the dimension [Static Field1] with [OB.Task.Task Indicator] and [Static Field2] with [OB.Call.Activity.Status] and use the expression I suggested.

Re: total

Fri, 01 Aug 2014 06:45:19 GMT

Hi all,

Can anyone help me? Thanks too much in advance.