Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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])),
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
It's related to your dimensions in a straight table, so not all records might be counted for one row of your table.
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
Thanks Jonathan for the mention. Glad you found my previous response useful (and memorable!).
Steve
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
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
No Worries Steve,
I just figured "Give Credit where Credit's due".
Didn't realize there is a restriction on that link, good thing I mentioned you Steve and thanks Marco
Thanks all,
I was able to work round it using Steve Dark's suggestion/example...
Regards,