Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Bar chart with lots of data

Hi everybody!  

I have a time-dependent characteristic. I want to display it in the form of a bar chart. I create bar chart, dimensions is a date (depends on the selected date range), expression is the characteristic.

11.png

appears scroll

I want that all the characteristics fit without to scroll.

I use axes property Continius13.png

and scroll disappears. But also disappear and the individual bars.

12.png

I want to see the individual bars. Maybe can be done grouping data by month and show the sum value for the month. Depending on the selected dates change group (year, month, week, day).

Is it possible? if possible we would like to get an example of how to do.

1 Solution

Accepted Solutions
Not applicable
Author

In the end, I used a couple of bar charts with various groups and display conditions. thank you all!

View solution in original post

5 Replies
Roop
Specialist
Specialist

You are correct in that your chart is showing bars but there are too many so they are merging.

You can create a drill-down group from your time field:

So in dimension for the chart select edit groups

Add a calculated dimension of =Month(Time_Field)

Then add your Time_Field

Finally name the group as _Time (so that it appears at the top)

Edit chart dimensions and remove your existing Time_Field and replace it with _Time

Now your chart will have the months on the X-Axis and you will be able to click on the month to explore the days

Hope this helps

Roop
Specialist
Specialist

You may wish to change the Month(Time_Field) to:

=Month(Time_Field) & ' - ' & Year(Time_Field)

as you have multiple years - sorry

JoaquinLazaro
Partner - Specialist II
Partner - Specialist II

Hi:

In Chart Properties, tab Presentation you can enable/disable the chart scrolling and you can set up the number of bars that you want.

Hope it helps you.

Joaquín

JoaquinLazaro
Partner - Specialist II
Partner - Specialist II

Hi:

In Chart Properties, tab Dimensions push in Edit Group to Add a new one with three fields: year, month and date from the calendar of your dimension.


You should create a Drill-Down group and Cyclic Group to understand and to check the difference between both.


Hope it helps you.

Joaquín

Not applicable
Author

In the end, I used a couple of bar charts with various groups and display conditions. thank you all!