
1. Re: How to give DISTINCT for sum
Norbert Maijoor Oct 27, 2016 5:39 AM (in response to anjani divi)Hi Anjani,
Find my approach as reference below
COUNT(amount) or COUNTD(amount)
and Total(count(amount))

2. Re: How to give DISTINCT for sum
anjani divi Oct 27, 2016 11:30 PM (in response to Norbert Maijoor)Hi Maijoor,
Thanks a lot,
but i need sum of amount with DISTINCT, not for the count
.in the tableau we have DISTINCT with count, but how we will do for sum along with DISTINCT?

3. Re: How to give DISTINCT for sum
Sherzodbek Ibragimov Oct 28, 2016 7:34 PM (in response to anjani divi)I am trying to find out why you are using Distinct of Sums? I am just curious. Why don't give us more details of what you are trying to achieve with sample data and it will be more clear. Based on that we may come up with other workarounds rather than straight way, which doesn't work since both COUNTD and SUM are both aggregation and can;t further aggregated. Your solution can be easy as well as difficult based on your data structure, requirements and so on.

4. Re: How to give DISTINCT for sum
anjani divi Nov 8, 2016 11:39 PM (in response to Sherzodbek Ibragimov)Hi Sherzodbek,
i have qlikview calculation like this,
dimension is category
and metric is sum(DISTINCT invoice_amount)based on the dimension i need to get distinct sum for invoic amount,
so same thing i need apply in the tableau as well, in the tableau i found DICTINCT for Count,
but i need to use DISTINCT for Sum.
That's why i have posted in community for help
I hope you understand my problem.