Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
jspr
Contributor
Contributor
‎2021-10-14 05:07 AM

Combined and separate filter does not match to Qlik Sense

Hello everyone,

I created a table and added a filter for the table. When I filtered it separately for example the number of transactions for 2020 and 2021, it shows 2,417 and  1,864 respectively. But when I ticked both 2020 and 2021, the total transactions is 3,196 instead of 4,217. Any reason why it does not match?

255 Views
0 Likes
1 Reply
Or
MVP
MVP
‎2021-10-14 05:13 AM

That depends on what your table structure is and what your expression is...

For example, if you're using something like Count(distinct TransactionID), one transaction ID might appear in both 2020 and 2021 and thus not get counted twice.

237 Views
0 Likes