Qlikview File

Thu, 02 Jan 2014 09:49:53 GMT

Can anyone please paste attached qlikview code in the message because unable to open attached file

Re: Qlikview File

Thu, 02 Jan 2014 09:56:50 GMT

SET ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

SET MoneyFormat='£#,##0.00;-£#,##0.00';

SET TimeFormat='hh:mm:ss';

SET DateFormat='DD/MM/YYYY';

SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]';

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

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

Data:

LOAD APPL_ID,

app_date,

event_type,

Date(EVT_DTE, '$(DateFormat)') as EVT_DTE,

DecisionDate

FROM

[SampleData.xlsx]

(ooxml, embedded labels, table is Sheet1);

AnalysedLast:

LOAD

APPL_ID,

FirstValue(EVT_DTE) as AnalysedLastDate

resident Data

where event_type = 'analysed'

group by APPL_ID

order by EVT_DTE desc;

EnteredFirst:

LOAD

APPL_ID,

FirstValue(EVT_DTE) as EnteredFirstDate

resident Data

where event_type = 'entered'

group by APPL_ID

order by EVT_DTE;

Re: Qlikview File

Siva_Sankar — Thu, 02 Jan 2014 09:59:30 GMT

pfa

Re: Qlikview File

Thu, 02 Jan 2014 10:01:52 GMT

Thanks

topic Re: Qlikview File in QlikView

Qlikview File

Re: Qlikview File

Re: Qlikview File

Re: Qlikview File