Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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.