topic Re: Group yearly product sales by region in QlikView

Group yearly product sales by region

adley51788 — Wed, 25 Nov 2020 16:16:04 GMT

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?

Re: Group yearly product sales by region

YoussefBelloum — Mon, 12 Mar 2018 13:50:16 GMT

Hi,

Period is the equivalent of Year ?

Re: Group yearly product sales by region

adley51788 — Mon, 12 Mar 2018 14:03:46 GMT

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

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

Re: Group yearly product sales by region

YoussefBelloum — Mon, 12 Mar 2018 14:11:11 GMT

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 ?

Re: Group yearly product sales by region

adley51788 — Mon, 12 Mar 2018 14:16:21 GMT

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

Re: Group yearly product sales by region

YoussefBelloum — Mon, 12 Mar 2018 14:21:13 GMT

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