Group yearly product sales by region

[adley51788]

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?

[YoussefBelloum]

Hi,

Period is the equivalent of Year ?

[adley51788]

Yes - I only have 1 year of data. Essentially looking to use set analysis --

count({<product = {'=if(sum(sales)<10,1}>}Region)

[YoussefBelloum · Accepted solution]

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 ?

[adley51788]

So, products can go across regions. I want to show each region and the number of products with sales under 10.

[YoussefBelloum]

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