Script Help

[#1]

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",

[its_anandrjs]

Hi,

Write some thing like

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

Regards,

Anand

[hic · Accepted solution]

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

[its_anandrjs]

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

[#5]

Thanks alot it worked