topic String To Number Conversion in QlikView

String To Number Conversion

Anonymous — Thu, 11 Feb 2016 08:33:45 GMT

Hello,

I am having Budget Data in Excel with Month as Text Data Type in Excel.

In my QV month is appearing as Numeric, I tried to convert this Month of Excel into number like..

Num#(ExcelMonth) & num(ExcelMonth) but did not work out.

When I concatenating Excel month to Calender Month it is giving me 2 value i.e 1 as Numeric & 1 as String...

I have checked over community as well but no success

Pls suggest how to achieve same?

swuehl — Thu, 11 Feb 2016 08:42:31 GMT

Maybe like

LOAD

BudgetYear,

Month(Date#(BudgetYear & BudgetMonth,'YYYYMMM')) as BudgetMonth,

...

or just

LOAD

BudgetYear,

Month(Date#( BudgetMonth,'MMM')) as BudgetMonth,

...

smirkinaa — Thu, 11 Feb 2016 08:56:37 GMT

Hello, i suggest to create mapping table and use it.

MonthsForReplacing:

Mapping LOAD

StringName,

Number

FROM

(ooxml, embedded labels, table is Лист1);

Budget:

LOAD BudgetYear,

BudgetQuarter,

BudgetMonth,

ApplyMap('MonthsForReplacing',BudgetMonth) as BudgetMonthLikeNumber,

BudgetValue

FROM

(ooxml, embedded labels, table is Sheet1);