topic [ASK] why data aren't the same? in QlikView

[ASK] why data aren't the same?

Mon, 26 Jul 2010 08:13:43 GMT

hello..

i have a problem with my data in qlikview

the data in sql server isn't the same in qlikview

when i try to run it on my sql server, the data is available from 29000 to -2500

the syntax on sql server :

select datediff(d,coraccountdetail.cicildate,coraccountdetail.paiddate) as buset

from coraccountdetail

order by buset desc

but when i list it on qlikview, the data is only available from 30 to -30

the syntax on qlikview :

=(Day(PaidDate)-Day(CicilDate))

why is it happen?

is there anyone able to help me?

i have the deadline sort and this problem occur

😞

FYI, in qlikview i try to load only 1 table that containt the data

many thx..

[ASK] why data aren't the same?

jonathandienst — Mon, 26 Jul 2010 08:30:13 GMT

The Day() function returns the day of the month (1-31).

Use PaidDate-CicilDate if you want the difference in days.

Jonathan

[ASK] why data aren't the same?

Miguel_Angel_Baeyens — Mon, 26 Jul 2010 08:30:21 GMT

Hello,

Not sure about what you are trying to get in your chart, but using the Day() function in QlikView you are extracting the day from a date, so a range between 30 and -30 seems correct.

[ASK] why data aren't the same?

Mon, 26 Jul 2010 08:42:53 GMT

@Jo

thx Jo..

it works

🙂

@Mig

thx for participating Mig..

it is done now

🙂