Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Talk to Experts, a LIVE Q&A Webinar. Bring your Qlik Sense Business questions on Aug. 4th. Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

Accumulated sales chart in qliksense

I want to build an accumulated sales chart where the dimension is now set to be suppliers and the measure is the sales from the suppliers. what i want to change is that to show that majority is concentrated on small amounts of suppliers. so i am thinking to covert the dimension to accumulated number of suppliers as well (e,g, from 1---maximum). is there anyway to achieve this? thanks  

Labels (1)
1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Re: Accumulated sales chart in qliksense

You can use the rank function to replace the supplier dimension, it is not perfect if you have suppliers with the same rank but it will give you a good indication. Notice my green marked bars, they have the same number, but the total count is correct . 

image.png

To replace my "Supplier Name" dimension I've used this expression:

=aggr(rank(Sum(Likes),4,1), [Supplier Name])

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

6 Replies
Highlighted
Partner
Partner

Re: Accumulated sales chart in qliksense

kindly send me the  sample report of which you want

Highlighted
Partner
Partner

Re: Accumulated sales chart in qliksense

Ut sounds like you are trying to do a pareto analysis.  Please check out @Henric_Cronström  blog post Recipe for a Pareto Analysis – Revisited - “Which products contribute to the first 80% of our turnover?”

Plees ekskuse my Swenglish and or Norweglish spelling misstakes
Tags (1)
Highlighted
Creator III
Creator III

Re: Accumulated sales chart in qliksense

Hi Vegar,

 

yes, that is what I want but I also want to show the horizontal as the accumulated number of suppliers, (e,g  not the actual supplier name)

Highlighted
Partner
Partner

Re: Accumulated sales chart in qliksense

You can use the rank function to replace the supplier dimension, it is not perfect if you have suppliers with the same rank but it will give you a good indication. Notice my green marked bars, they have the same number, but the total count is correct . 

image.png

To replace my "Supplier Name" dimension I've used this expression:

=aggr(rank(Sum(Likes),4,1), [Supplier Name])

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

Highlighted
Creator III
Creator III

Re: Accumulated sales chart in qliksense

Hi Vegar,

 

another question, is it possible to squeeze the horizontal scale? as I got thousands of suppliers and I understand each number is representing a supplier and not actual continues measures, but just to see if options available to squeeze the axe within one page without horizontal bar being used 

Highlighted
Partner
Partner

Re: Accumulated sales chart in qliksense

Try to activate continous axis in your chart X-axis properties.

image.png

 

- Vegar

Plees ekskuse my Swenglish and or Norweglish spelling misstakes
Tags (1)