Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

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: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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: 
Kwame
Contributor III
Contributor III
‎2023-11-21 03:32 PM

Distinct Sum

Hi Guys!

I want to get a distinct total at the backend even after joining two tables, that is the bal total should read 1088 and not 4353.

The sample file is attached. Thanks.

Kwame_1-1700598756097.png

Labels (3)
Labels
Preview file
9 KB
681 Views
1 Solution

Accepted Solutions
jochem_zw
Employee
Employee
‎2023-11-21 03:52 PM

see attachment

View solution in original post

Qlik_Community_Help.qvw
660 Views
1 Reply
jochem_zw
Employee
Employee
‎2023-11-21 03:52 PM

see attachment

Qlik_Community_Help.qvw
661 Views