Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

Need Help in Qlikview Aggregate function?

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@

Tags (1)
1 Solution

Accepted Solutions
Highlighted
Specialist
Specialist

Re: Need Help in Qlikview Aggregate function?

Hi,

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

expres.png

View solution in original post

2 Replies
Highlighted
Specialist
Specialist

Re: Need Help in Qlikview Aggregate function?

Hi,

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

expres.png

View solution in original post

Highlighted
Contributor
Contributor

Re: Need Help in Qlikview Aggregate function?

Thank You, It worked.

Regards

Sujay