Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

values as dimension

Qlik community,

I would like to use a number of values ​​for a dimension. For example, I want to classify customers based on the number of orders. Customers who order once a week, order twice a week and order three times a week. Then I want to make a dimension of this to see how many customers fall into each category. I use Count (distinct (invoice)) / number_of_weeks to measure the ordering frequency. From this, therefore, 0-1, 1-2, 2-3 & 3+ must come as different dimensions in one field. Anyone have any idea? Thanks in advance!

Labels (1)
2 Replies

Creator II
Creator II

perhaps a calculated dimension using aggr?