Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
Not applicable

Bar Chart Time Sorting

Hello,

I am a new Qlik user, and am just starting in the world of analytics.

I have a client that recently asked me to build a "Beat Rate" chart in Qlik. Apparently this type of chart comes from a Six Sigma methodology.

I thought this kind of implementation would be simple, as basically it is just recreating a trend. The data recorded on a production line looks like this.

My load script looks like this.

Dead simple, 2 columns, one with a time stamp, one with a value. The above is a snip of sample data that I have manually generated, but the source data will by coming from an SQL query that looks the same as above.

I want to use a bar chart that basically gives me the value for a given time stamp ordered by time ascending. However when I load the data into the Qlik Sense bar chart tool, I get this.

All of the values are grouped together, with a bunch of leading zero records. They are not ordered numerically ascending by time.

I've added time as a dimension and beat rate as a value.

When I apply sorting options, it seems to only sort the label associated with the data, and not the order of the data itself.

I want this bar chart to be sorted linearly by time. My sorting option look like this.

This also doesn't make sense to me. If this bar graph is a representation of "sorting by load order" why would Qlik on the data import, first import all the 0 records, and then the records with values? This makes no logical sense.

Thanks in advance for any help. I'm very new at this!

Cheers,

Tags (2)
1 Solution

Accepted Solutions

Re: Bar Chart Time Sorting

Hi,

All you have to do is Drag the "TimeField" at top.

First Sort criteria should be on "TimeField" instead of "Bit Rate".

Regards,

Kaushik Solanki

View solution in original post

2 Replies

Re: Bar Chart Time Sorting

Hi,

All you have to do is Drag the "TimeField" at top.

First Sort criteria should be on "TimeField" instead of "Bit Rate".

Regards,

Kaushik Solanki

View solution in original post

Not applicable

Re: Bar Chart Time Sorting

Thank you so much, I knew it had to be something simple I was missing!

Worked like a charm! I didn't realize it sorted in order of listing in the sort tab. I'll remember this for next time.

Sort order now appears as follows

Bar Chart now looks like this

Again thanks so much!

Jesse