- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Group yearly product sales by region
Looking to create a bar chart to do the following in Qlikview:
Sample Data:
Region, Product, Sales, Period
1,2,1,1
1,2,3,2
1,2,4,3
2,2,4,1
So, If I wanted to count the individuals products that sold less than 10 times per year, what would be the best method?
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
To count the individuals products that sold less than 10 times per year, you can do this:
count({<product = {"=sum(sales)<10"}>}Product)
now it depends on how you want to integrate the year value in this analysis, you want to select the year ? you want it to be static on a specific year ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Period is the equivalent of Year ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Yes - I only have 1 year of data. Essentially looking to use set analysis --
count({<product = {'=if(sum(sales)<10,1}>}Region)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
To count the individuals products that sold less than 10 times per year, you can do this:
count({<product = {"=sum(sales)<10"}>}Product)
now it depends on how you want to integrate the year value in this analysis, you want to select the year ? you want it to be static on a specific year ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
So, products can go across regions. I want to show each region and the number of products with sales under 10.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
If you want to show the count of each region, juste use the Region field on the dimensions and use the expression I gave you