Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
_akhan7qv
Partner
Partner

Sum() of id dimension duplicated in bar chart

Hello,

I have a table which contains a set of references, in a group, with a number to sum() on a given month, it goes like this:

forum_qv.PNG

I'd like to display in my bar chart the number of SUM() of "canaux" for a "refcom" for each month (janv and feb) regardless of the "sub" field. So I should have for each month 10 and not 20, how can I do this ?

 

Currently my expression is just sum(canaux) and my dimension "mois"

 

Regards,

2 Replies
MayilVahanan

Hi @_akhan7qv 

Can you try with distinct 

 sum(distinct canaux)

Thanks & Regards,
Mayil Vahanan R
_akhan7qv
Partner
Partner
Author

Hi, in this small example I provided it will work but on a bigger project it won't because I can have the same value for "canaux" several times for different refcoms.

I'd like to compute the sum() of canaux for each month based on the number of refcoms and deduplicating the field "sub"