topic Re: Expression result in text object different from Chart Object in QlikView

Expression result in text object different from Chart Object

Fri, 19 Dec 2014 13:28:35 GMT

Hi all,

Please kindly assist me,

If I put the expression below in a text object it returns 114 - This is right based on Excel calculation.

=Count({$<[Previous Month] = {'Telephone'}>} [Sales Date])

However, if I put any of the expressions below in a Straight table they return 94.

Count({<[Previous Month] = {'Telephone'}>} [Sales Date]),
Count({$<[Previous Month] = {'Telephone'}>} Sales Date]),
Count(if([Previous Month] = 'Telephone',[Sales Date])),

Re: Expression result in text object different from Chart Object

MarcoWedel — Fri, 19 Dec 2014 13:32:30 GMT

It's related to your dimensions in a straight table, so not all records might be counted for one row of your table.

Re: Expression result in text object different from Chart Object

jpenuliar — Fri, 19 Dec 2014 13:36:35 GMT

I've had a similar situation like yours before, here's how it was explained by stevedark

Table box Rows does not match Charts/expressions/statistics aggregates

Re: Expression result in text object different from Chart Object

stevedark — Fri, 19 Dec 2014 15:22:59 GMT

Thanks Jonathan for the mention. Glad you found my previous response useful (and memorable!).

Steve

Re: Expression result in text object different from Chart Object

MarcoWedel — Fri, 19 Dec 2014 16:23:39 GMT

Hi,

I'm getting this message when trying to open the link.

Is this thread published in a private forum or is there an issue of the community site?

thanks

regards

Marco

Re: Expression result in text object different from Chart Object

stevedark — Fri, 19 Dec 2014 16:29:35 GMT

Sorry Marco - the link goes to a post in the Qlik UK group. There is a bit of discussion in that closed group - but the most useful thing is a link to this post, where I have posted up an example app illustrating this issue:

Re: Sum equation versus Sum rows in straight table

Thanks for pointing out the broken link.

Steve

Re: Expression result in text object different from Chart Object

jpenuliar — Fri, 19 Dec 2014 16:36:25 GMT

No Worries Steve,

I just figured "Give Credit where Credit's due".

Re: Expression result in text object different from Chart Object

jpenuliar — Fri, 19 Dec 2014 16:38:21 GMT

Didn't realize there is a restriction on that link, good thing I mentioned you Steve and thanks Marco

Re: Expression result in text object different from Chart Object

Mon, 22 Dec 2014 12:34:01 GMT

Thanks all,

I was able to work round it using Steve Dark's suggestion/example...

Regards,