topic Re: Getting wrong answer in QlikView

Getting wrong answer

Tue, 05 Feb 2013 10:49:16 GMT

In my chart I am trying this expression to get product age

timestamp(Date(today()) - Date(poentrydate), 'Y') * 12 + timestamp(Date(today()) - Date(poentrydate), 'M')

so that i will get age in months .

but using above expression getting high values .. y? can someone help me?

also when i just use

timestamp(Date(today()) - Date(poentrydate), 'Y')

i am getting right answer adding multilplying getting big values

Re: Getting wrong answer

jonathandienst — Tue, 05 Feb 2013 11:10:38 GMT

What you need is:

(Year(Today()) - Year(poentrydate)) * 12 + Month(Today()) - Month(poentrydate)

Hope that helps

Jonathan

Re: Getting wrong answer

Tue, 05 Feb 2013 11:14:03 GMT

i wrote same expression before and guess what i was not seeing anything so i thought i am not getting answer

but my window was small and answer was coming but i had to scrollll .. wasted so much time..

Thanks Jonathan

Re: Getting wrong answer

Tue, 05 Feb 2013 11:15:41 GMT

Can you just explain why i was getting big numbers???

Re: Getting wrong answer

jonathandienst — Thu, 07 Feb 2013 07:04:39 GMT

Because timestamp(.., 'Y') does not convert the date to a year number - it formats it to display only a year number, but is internally unchanged. Therefore you were mutliplying a date number (a number of about 41000) by 12. The same applies to timestamp(..., 'M').

The correct way to convert the values are the Year and Month functions.

Regards

Jonathan

Re: Getting wrong answer

Thu, 07 Feb 2013 09:13:04 GMT

thank you Jonathan