topic Re: date in QlikView

date

upaliwije — Sun, 06 Sep 2015 07:58:42 GMT

Hi Friends

DUAL( DATE(POL_PERIOD_FROM,'MMM-YY') &' - '& DATE(POL_PERIOD_TO,'MMM-YY'),POL_PERIOD_FROM) AS POLICY_PERIOD

pls help me to write systax to extarct Date from (POL_PERIOD_FROM) from the above syntax

Re: date

qlikviewwizard — Sun, 06 Sep 2015 08:09:19 GMT

Hi,

Can you attach the sample file with the data?

Re: date

upaliwije — Sun, 06 Sep 2015 08:14:02 GMT

The the QV sample cannot be attached. I want to know where date can be separately identified from my systanx

Re: date

qlikviewwizard — Sun, 06 Sep 2015 08:16:50 GMT

Hi,

Can you give some sample data of POL_PERIOD_FROM,POL_PERIOD_TO?

Are you using default SET configurations?

SET ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

SET MoneyFormat='$#,##0.00;($#,##0.00)';

SET TimeFormat='h:mm:ss TT';

SET DateFormat='M/D/YYYY';

SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

Re: date

Anonymous — Sun, 06 Sep 2015 08:17:08 GMT

What does your POL_PERIOD_FROM field consists of ?

Re: date

sunny_talwar — Sun, 06 Sep 2015 08:17:20 GMT

Not sure what you mean? You already have POL_PERIOD_FROM which you are using to create POLICY_PERIOD. Are you looking to again extract POL_PERIOD_FROM from POLICY_PERIOD?

Re: date

upaliwije — Sun, 06 Sep 2015 08:20:27 GMT

Yes I want to extract POL_PERIOD_FROM and link same to master calender

Re: date

sunny_talwar — Sun, 06 Sep 2015 08:21:59 GMT

May be this:

Date(Num(POLICY_PERIOD) as POL_PERIOD_FROM