Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Kaushik2020
Creator III
Creator III

Bar chart

Dear all, 

If you see the bar chart and line chart, the bars and data points are not in sync - means the alignment of the data is not correct in terms of presentation. (No data issue)

Expectation is that the bars should cover the full space (right side empty space in below image) same as the line chart instead of showing empty spaces on the right side.

kaushi2020_0-1702449923190.png

Expression for bar chart:

(Count({$<Year=, Month=, Day=,Contact_Center={'Digital'},
Date={">=$(=date(monthstart(max(Date))))<=$(=date(max(Date)))"}>}
Distinct AgentID))

 

Expression for Line chart (below the bar chart):

((count({$<Year=, Month=, Day=,Contact_Center={'Digital'},HandlingTime={">0"},
Date={">=$(=date(monthstart(max(Date))))<=$(=date(max(Date)))"}>}
SequenceID))

/

((Count({$<Year=, Month=, Day=,Contact_Center={'Digital'},
Date={">=$(=date(monthstart(max(Date))))<=$(=date(max(Date)))"}>}
Distinct AgentID))))

 

thanks in advance.

 

Labels (5)
1 Solution

Accepted Solutions
F_B
Specialist II
Specialist II

Hi,

yes, I know, this is something that can be improved in visualization options, but just play around with the following settings and you'll get it: 

*Bar chart properties

*X-axis 

*Number of bars

*Custom

Hope this helps,

bye

View solution in original post

4 Replies
F_B
Specialist II
Specialist II

Hi,

yes, I know, this is something that can be improved in visualization options, but just play around with the following settings and you'll get it: 

*Bar chart properties

*X-axis 

*Number of bars

*Custom

Hope this helps,

bye

Kaushik2020
Creator III
Creator III
Author

thanks for the reply. by changing below ones was able to achieve the ask.

kaushi2020_0-1702468585839.png

 

Kaushik2020
Creator III
Creator III
Author

just checked when Day = 1. below is how the graph is show. if i reduce the width - it will not work as it will impact all the other days bar length. any suggestions ? 

kaushi2020_0-1702473447079.png

 

F_B
Specialist II
Specialist II

Unfortunately, when the number of bars is less than the max value set, the visualization adapts, and I'm facing the same effect in a few apps. I haven't found any properties settings to avoid it yet, maybe it's worth browsing into Ideation?