Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Register for Events and Webinars directly from Qlik Community: http://bit.ly/2Vpnenx
Highlighted
patrou38
Contributor

Re: Sum quantity

Enclosed my excel file used as calendar.

thank you again for your precious help.

Patrick

Re: Sum quantity

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))

View solution in original post

Highlighted
patrou38
Contributor

Re: Sum quantity

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