Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Share calculations

Having trouble getting time period specific share calculations to work correctly. 2 dimensions (product and month). Assume 3 months and 2 products selected. LIne chart will show monthly sales for each product for each month (6 data points). Need expression that will convert each product/month sales to a percentage of all product's sales for the month.

Tried variation of set analysis, total qualifier, and AGGR function but cannot get to work.

1 Reply
Not applicable
Author

Issue resolved. Object built with time cycle group as dimension. use of AGGR function worked once appropriate dimension variable name was used.