topic Re: Evaluate InLine Formula in QlikView

Evaluate InLine Formula

Anonymous — Wed, 18 Feb 2015 18:03:27 GMT

Hi All

Is there anyway to evaluate formula from InLine statement?

Based on vCurrPrd selection calculating four dimension

Where vCurrPrd can be 30/09/2014 or 31/12/2014 in Date format

QtrNewDim:

LOAD * INLINE [
QtrNDim

'Q' & Ceil(Month(AddMonths(vCurrPrd,3))/3) & '-' & Right(Year(AddMonths(vCurrPrd,3)),2)
'Q' & Ceil(Month(AddMonths(vCurrPrd,6))/3) & '-' & Right(Year(AddMonths(vCurrPrd,6)),2)
'Q' & Ceil(Month(AddMonths(vCurrPrd,9))/3) & '-' & Right(Year(AddMonths(vCurrPrd,9)),2)

'Q' & Ceil(Month(AddMonths(vCurrPrd,12))/3) & '-' & Right(Year(AddMonths(vCurrPrd,12)),2)
];

Thanks to all

Re: Evaluate InLine Formula

Anonymous — Wed, 18 Feb 2015 18:14:49 GMT

Based on vCurrPrd selection calculating four Quarters (Not Dimension)

Re: Evaluate InLine Formula

Anonymous — Wed, 18 Feb 2015 18:20:38 GMT

Have a look at the QlikView Evaluate() function.

Re: Evaluate InLine Formula

Anonymous — Wed, 18 Feb 2015 18:50:07 GMT

Hi Bill

I am getting none with below scripting. Do I forget any in below script?

I have used = sign at begining too.

Thanks for your valuable reply

QtrSourceDim:

LOAD * INLINE [
QtrNDim
'Q' & Ceil(Month(AddMonths(vCurrPrd,3))/3) & '-' & Right(Year(AddMonths(vCurrPrd,3)),2)
'Q' & Ceil(Month(AddMonths(vCurrPrd,6))/3) & '-' & Right(Year(AddMonths(vCurrPrd,6)),2)
'Q' & Ceil(Month(AddMonths(vCurrPrd,9))/3) & '-' & Right(Year(AddMonths(vCurrPrd,9)),2)
'Q' & Ceil(Month(AddMonths(vCurrPrd,12))/3) & '-' & Right(Year(AddMonths(vCurrPrd,12)),2)
];

QtrTargetDim:
LOAD evaluate(QtrNDim) As NewQtrs
Resident QtrSourceDim;

Re: Evaluate InLine Formula

anbu1984 — Thu, 19 Feb 2015 03:19:24 GMT

Set vCurrPrd='41912';

Load A,B,'Q' & A & '-' & B As QtrNDim;

LOAD Evaluate(A) As A,Evaluate(B) As B INLINE [

A,B

'Ceil(Month(AddMonths($(vCurrPrd),3))/3)', 'Right(Year(AddMonths($(vCurrPrd),3)),2)'

'Ceil(Month(AddMonths($(vCurrPrd),6))/3)', 'Right(Year(AddMonths($(vCurrPrd),6)),2)'

'Ceil(Month(AddMonths($(vCurrPrd),9))/3)', 'Right(Year(AddMonths($(vCurrPrd),9)),2)'

'Ceil(Month(AddMonths($(vCurrPrd),12))/3)', 'Right(Year(AddMonths($(vCurrPrd),12)),2)'

];

Re: Evaluate InLine Formula

Anonymous — Fri, 20 Feb 2015 19:46:32 GMT

Helpful answer, Thanks Anbu