topic Re: Script Help in QlikView

Script Help

Tue, 13 Nov 2012 07:50:49 GMT

How do u convert the following in qlikview syntax.. sorry am very new coming from a sql background so i might have a look of silly questions today considering the project am working on

TRUNC("POL_PAID_TO_DATE" - "POL_CRT_DATE") / 31) As "Converted Count",

Re: Script Help

its_anandrjs — Tue, 13 Nov 2012 08:08:09 GMT

Hi,

Write some thing like

(POL_PAID_TO_DATE - POL_CRT_DATE) / 31 as [Converted Count]

Regards,

Anand

Re: Script Help

hic — Tue, 13 Nov 2012 08:17:32 GMT

The QlikView Floor() function does almost the same as the SQL TRUNC(). Further, to quote fields, you can use either double quotes "" or square brackets [] in QlikView. Hence, the following should work:

Floor(("POL_PAID_TO_DATE" - "POL_CRT_DATE") / 31) As "Converted Count",

HIC

Re: Script Help

its_anandrjs — Tue, 13 Nov 2012 08:21:28 GMT

Hi,

You can use Ceil of Floor functions for this like

Ceil( (POL_PAID_TO_DATE - POL_CRT_DATE) / 31) as [Converted Count]

Floor( (POL_PAID_TO_DATE - POL_CRT_DATE) / 31) as [Converted Count]

Regards,

Anand

Re: Script Help

Tue, 13 Nov 2012 08:37:08 GMT

Thanks alot it worked