I've ran into a problem while writing some expressions, based on some MySQL queries, in a pivot table in QlikView. The results between the said query and the expression is completely different for most of the users but not for all.
The query is:
SELECT distinct date(initiated_date) FROM activities
where deleted = 0
and activity_type_id != 8
The expression is: Count({<activity_type_id -= {'8'}>} distinct initiated_date)
I'm counting the query results' rows for different users,users that I'm using as dimension in the pivot table. For some users the results match(the number of rows resulted in the query equals the result of the Count expression that I'm using in the pivot table) but for others it doesn't.
Why? Am I missing something regarding the count expression ? If so, how should I write the expression?
