Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Expression result in text object different from Chart Object

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])),


1 Solution

Accepted Solutions
MVP
MVP

Re: Expression result in text object different from Chart Object

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

8 Replies

Re: Expression result in text object different from Chart Object

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

jpenuliar
Valued Contributor III

Re: Expression result in text object different from Chart Object

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

MVP
MVP

Re: Expression result in text object different from Chart Object

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

Hi,

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

QlikCommunity_Thread_146357_Pic1.JPG

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

thanks

regards

Marco

MVP
MVP

Re: Expression result in text object different from Chart Object

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

jpenuliar
Valued Contributor III

Re: Expression result in text object different from Chart Object

No Worries Steve,

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

jpenuliar
Valued Contributor III

Re: Expression result in text object different from Chart Object

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

Not applicable

Re: Expression result in text object different from Chart Object

Thanks all,

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

Regards,

Community Browser