topic Need Help in Qlikview Aggregate function? in QlikView

Need Help in Qlikview Aggregate function?

Anonymous — Tue, 24 Oct 2017 00:24:45 GMT

Hi,

Can someone help me to solve this.

I have included the details in the attached qvw file.

I need to calculate number of weeks each style_color_code is sold.

Units Field - number of units sold, if units is -1, 1 unit is returned. no need to consider returns.

Regards

Sujay Babu@

el_aprendiz111 — Tue, 24 Oct 2017 01:36:48 GMT

Hi,

Sum(Aggr(Count ( DISTINCT{<Units={'>=1'}>}Merch_Year_Week),Style_Color_Code,Merch_Year_Week))

Anonymous — Tue, 24 Oct 2017 03:31:39 GMT

Thank You, It worked.

Regards

Sujay