Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
patrou38
Creator
Creator

Sum quantity

Hello,

I have a table in which there are a quantity of equipment by week (February weeks in my example).

in another table I would like to have the sum of qty by month.  I don't find the expression, the aggr ????

I expect that I'm enough clear.

than you for your help.

Patrick

12 Replies
patrou38
Creator
Creator
Author

Enclosed my excel file used as calendar.

thank you again for your precious help.

Patrick

sunny_talwar

Oh... I see that you are doing a Distinct count... I am not sure why you need a DISTINCT... but if you need that... may be try this

Sum({<Facility = {'$(vFacility)'}, ModelFamily = {'$(vModelFamily)'}>} Aggr(Sum(DISTINCT {<Facility = {'$(vFacility)'}, ModelFamily = {'$(vModelFamily)'}>} [TC inventory]), Year_Week, Year_month))

patrou38
Creator
Creator
Author

guys,

I want to thank you very very much for your prompt and precious help... it's really appreciate.

have a good rest of the day

best regards,

Patrick