topic Re: Problem with data Minutes & Hours in QlikView

Problem with data Minutes & Hours

Mon, 18 Jul 2016 18:35:57 GMT

Problem with data Minutes & Hours

Table in a box chart, I have a field whose data Hours and minutes.

When exporting to excel that table without making any selection, bring me the right thing, but if I make a selection with month and / or year when exporting to excel the data that brings me are signs like these "### ######### "as the first action try to open more cell thinking that the data was a bit large, it did not work. Then try to change the format directly excel to bring the data as needed, it did not work. I transformation in the field with a Timestamp function, but neither worked.

In theory, if there were problems with the data without any selection nor would I show, but that's the problem without selection if it brings, making selection I bring it with these signs and if I see the amount of data is a number negative with more than 18 characters.

Has anyone had this problem?

Any suggestions?

Leave pictures ...

Occupying "Timestamp"

Table box in QlikView, unfiltered month or year.

It is exported to Excel and brings me the correct data.

This is the problem when I export to Excel table by filter by year and / or month.

That fact brings me when I select the cell.

Re: Problem with data Minutes & Hours

Clever_Anjos — Mon, 18 Jul 2016 18:44:32 GMT

Try

Timestamp(Frac(ERZET),'hh:mm:ss'))

Re: Problem with data Minutes & Hours

Mon, 18 Jul 2016 20:53:04 GMT

Thanks Clever, I tried and not change the result.

I have the same problem

Re: Problem with data Minutes & Hours

swuehl — Mon, 18 Jul 2016 21:35:41 GMT

Could you post a small sample QVW?

Re: Problem with data Minutes & Hours

Mon, 18 Jul 2016 22:55:51 GMT

I think whats the problem, i use in the properties the format to hours into the chart.

I realized that if I do not select the "Ignore document settings " in the tab number , I respect the format of the data in that field.

Do you think, this is the problem?

Re: Problem with data Minutes & Hours

Wed, 20 Jul 2016 16:41:09 GMT

I applied this function "TIME#(hh,mm,ss)" and fixed the problem

Re: Problem with data Minutes & Hours

Clever_Anjos — Wed, 20 Jul 2016 16:59:44 GMT

Weird,

As long as I know Time#() function has 2 parameters (text,format).

Never read about a third one