topic Re: how to add? in QlikView

how to add?

balasundaram — Sat, 06 Sep 2014 14:21:52 GMT

='Total '& Count([Moc.Type .])+Count(Moc.Type.)

above expression i written in under presentation tab in "TEXT IN CHART" , i am trying to show total count,but i used sum not working

Re: how to add?

MarcoWedel — Sat, 06 Sep 2014 14:36:57 GMT

please provide sample app/data

Re: how to add?

JonnyPoole — Sat, 06 Sep 2014 15:49:09 GMT

If you change it to just the word total does it work? If not try changing the font color to make it more conspicuous it may be hidden.

If the word total by itself works then add the 1st count by itself and see if that works... This should tell you which part of your 3 part expression is failing.

Re: how to add?

IAMDV — Sat, 06 Sep 2014 16:59:39 GMT

Hi,

Looking at your expressions there are two potential issues.

balasun per wrote:

='Total '& Count([Moc.Type .])+Count(Moc.Type.)

1. Your second expression i.e. Count(Moc.Type.) should be Count([Moc.Type.]). I'm not sure if these are right field names but I recommend you to use the square brackets around the field names when there is period or space.

2. When you are aggregating the data (In your case - it's Count) in different expressions and using a string concatenation operator, you need brackets around the two aggragation expressions (See the read brackets marked below).

So you need to use something like this:

='Total '& (Count([Moc.Type .])+Count([Moc.Type.]))

I hope this helps!

Cheers,

www.QlikShare.com

Re: how to add?

israrkhan — Sat, 06 Sep 2014 16:59:59 GMT

Yes, its not working.... dont know why...

but if you keep Total at the end then its working..like below..

= sum(Sales) + Count(Sales)&' Total ...............its working

OR you just do sum and count in "text in chart" and create a text object for Total, make it transparent, and just put it left to your total value...

Hope it helps....

Re: how to add?

preminqlik — Sat, 06 Sep 2014 17:09:52 GMT

hi ,

keep it in variable like

='Total : '&(Count(field)+count(Field2))...and use that variable

Re: how to add?

IAMDV — Sat, 06 Sep 2014 18:03:29 GMT

Prem - Curious to know, how will variable help compared to normal expression?

Re: how to add?

israrkhan — Sat, 06 Sep 2014 18:41:23 GMT

me too... 🙂

have tried, not working even in variable...

Re: Re: how to add?

IAMDV — Sat, 06 Sep 2014 18:48:11 GMT

This expression works for me:

So you need to use something like this:

='Total '& (Count([Moc.Type .])+Count([Moc.Type.]))

Cheers,

Re: how to add?

israrkhan — Sat, 06 Sep 2014 18:58:51 GMT

Yes, for me too...

but logically these () does not make sense.

I consider it, a qlikview fault......

anyway Thanks for.......

Re: Re: how to add?

IAMDV — Sat, 06 Sep 2014 19:46:08 GMT

Good to know it works for you. But it's not QlikView's fault but that's natural behaviour in programming paradigm. The reason for this behaviour is the nature of the operators used in the expression and the order of precedence. I would recommend you to read - The Order of Precedence of arthimetic operators for clear understanding. However, Let me try to explain:

='Total '& (Count([Moc.Type .]) + Count([Moc.Type.]))

Above expression won't work without the brackets (in red colour) because we are using "+"/addition arthimetic operator and when we use the brackets then QlikView aggregates the both the count values and then adds them together. So if there are no brackets the expression evaulation might be confusing with the string concatenation operator and it returns a NULL value.

However, below expression works without the same brackets when we use the "*"/multiplier arthimetic operator because this operator take first precedence when we don't specify any brackets.

='Total '& Count([Moc.Type .]) * Count([Moc.Type.])

So, it's important to explicity specify the brackets whenever writing the expressions and not depending on the Order of precedence.

I hope all this makes sense!

Cheers,