Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
ssijbabu
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@

1 Solution

Accepted Solutions
el_aprendiz111
Specialist
Specialist

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
el_aprendiz111
Specialist
Specialist

Hi,

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

expres.png

ssijbabu
Contributor
Contributor
Author

Thank You, It worked.

Regards

Sujay