Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

yangcelinexu
Contributor

Histogram/Bar chart define the X axis limitation, calculation function learning

Hi, wondering,

could anyone give some guidance how to create the limitation of X axis. for Histogram and Bar chart

1. I have a histogram distribution concentrate from 0--2000, but still have a long tail from 2000-6000. I want to limit the graph only showing the distribution from 0-1000.

How could define the limits of the X  axis from 0-1000?

2. Same problem here:if I have about 10000 product name (Name), each name have multiple rows.  and I want to create a flip bar chart having the top 20 product names as X axis and have count how many row for each product name as Y and ranking criteria .

I do not have 'row number' for counting, each row have following fields:

customID, time, Name(product name), #product, payment  

But, I want to count the how many of rows exit for each Name. How should I construct the 'count' function. And then limit the graph only showing first 20 products.

Thank you!

could I also know where could I find more info /videos regarding how to use Calculation function in Qlik sense? Want to learn more.

Thank you!

Community Browser