topic Re: Dates and Stacked Bar Chart in QlikView

Dates and Stacked Bar Chart

brf10043 — Wed, 25 Nov 2020 16:16:04 GMT

Team,

I have a time stamp that I am pulling for a Remedy system. I'm adjusting it because the date is stored as seconds since 1970 (I think)

Date((ARRIVAL_TIME/ 86400 + 25569),'DD-MM-YYYY hh') as [IM Arrival Date Hour],

I end up with a value that looks like the list box below which looks like what I'm after.

Now, I'm trying to chart this data along with "Category" data in a stacked bar chart. The problem that I am having is that even though I'm selecting a stacked in the style tab, they are not being stacked. I am trying to get the different categories stack by date hour into a single bar. but I get individual bars.. See below.

Here is my demission. The cyclic toggles between the date and the date hour timestamp

Any ideas?

Re: Dates and Stacked Bar Chart

sunny_talwar — Thu, 04 Oct 2018 19:05:26 GMT

Try this

Date(Floor((ARRIVAL_TIME/ 86400 + 25569), 1/24),'DD-MM-YYYY hh') as [IM Arrival Date Hour],

Re: Dates and Stacked Bar Chart

brf10043 — Thu, 04 Oct 2018 19:14:38 GMT

Thanks Sunny! I don't understand why, but works perfectly!

Re: Dates and Stacked Bar Chart

sunny_talwar — Thu, 04 Oct 2018 19:31:03 GMT

Although, you were seeing only up until hours because of your formatting, the underlying value still included minutes and seconds information. By using Floor, we removed the minutes and seconds which made stacking possible.

Re: Dates and Stacked Bar Chart

brf10043 — Thu, 04 Oct 2018 19:33:16 GMT

Thanks Sunny. That makes sense now that you have explained it.

Thanks again!