topic Re: Timestamp on Qlikview Combo Chart in QlikView

Timestamp on Qlikview Combo Chart

Chiru — Tue, 02 Mar 2021 01:19:28 GMT

Hello All,

I am trying to create combo chart for the jobs completions status. There are 5 runs per day and I can take the max(time) to display in chart. But I am unable to display the timestamp in the combo chart y axis. it is showing 0.00 or some dates with 1900 as year. I tried Frac(),only() etc but still its not working. Anyone please help me to resolve this.TIA

Re: Timestamp on Qlikview Combo Chart

avinashelite — Tue, 02 Mar 2021 05:44:56 GMT

I think you need to correct the date format, could you please share the sample data set so that we could help.

Re: Timestamp on Qlikview Combo Chart

Chiru — Tue, 02 Mar 2021 06:31:36 GMT

I am just extracting time from database like 01:32 and trying to fetch in dashboard. Also I tried to pass the time in different format, like timestamp etc.. but its not working with any of the format