
Creator
2019-04-04
11:42 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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!
618 Views
2 Replies

Partner - Master III
2019-04-04
12:24 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
think you might need value list
check below
https://community.qlik.com/t5/Qlik-Design-Blog/ValueList-For-those-tricky-situations/ba-p/1476275
check below
https://community.qlik.com/t5/Qlik-Design-Blog/ValueList-For-those-tricky-situations/ba-p/1476275
612 Views

Creator II
2019-04-04
06:16 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
perhaps a calculated dimension using aggr?
599 Views
