QS Feb2020 Convert String to Number | Script Error | when Concatenate Tables

lylererger — Sat, 16 Nov 2024 18:50:05 GMT

Hi all

Already spent 2 hours on an elementary task. No matter how hard I try, nothing comes out.

I am trying to add another artificial value "1111" to the ID field, but when Concatenating this table, the integer format is interpreted as String. Any squats in this regard did not give any success.

Look at the simple Script:

tmpData: LOAD * Inline [tmpField];

tmp_1:

LOAD

type_period&'|'&level_name&'|'&Num(dt) as [% ПК],

ID_POK_N as [ПоказательID],

type_period as [Уровень Период],

level_name as [Уровень Имя],

Year(dt)&Num(Month(dt),'00') as [ГодМесяц],

Month(dt)&Right(Year(dt),2) as [МесяцГод],

Date(dt) as [Дата],

Num(dt) as [ДатаЧисло],

P_name as [Показатель Имя],

"fact" as [Факт],

plan as [План]

FROM [lib://marketShare/QVD/DataTier1/KFLPKVK.qvd](qvd)

Where Match(ID_POK_N,'110','111','112','114','170070458');

Left Join (tmp_1)

LOAD

type_period&'|'&level_name&'|'&Num(dt) as [% ПК],

sum("fact") as [Объём Рынка]

FROM [lib://marketShare/QVD/DataTier1/KFLPKVK.qvd](qvd)

Where Match(ID_POK_N,'170070459')

Group By

type_period&'|'&level_name&'|'&Num(dt);

Concatenate (tmp_1)

Load

[% ПК],

Num#(1111,'# ##0') as [ПоказательID],

sum([Объём Рынка]-[Факт]) as [Факт]

Resident tmp_1 Group By [% ПК];

Doesn't works:

1. Num(1111,'# ##0')

2. Num(1111)

3. Num#(1111,'# ##0')

4. Num#(1111)

5. 1111 as [ПоказательID]

6. (1111)*1

7. Evaluate(1111)

8. Evaluate(1111) *1

9. Any kind of transformations doesn't works...

So it looks like 'surprise' from Qlik

Please help me fix that bug.

Thanks in advance

Re: QS Feb2020 Convert String to Number | Script Error | when Concatenate Tables

kaushiknsolanki — Mon, 06 Apr 2020 07:39:30 GMT

Hi Try this.

Num(Num#(1111))

Re: QS Feb2020 Convert String to Number | Script Error | when Concatenate Tables

lylererger — Mon, 06 Apr 2020 08:46:09 GMT

Doesn't works

Re: QS Feb2020 Convert String to Number | Script Error | when Concatenate Tables

lylererger — Mon, 06 Apr 2020 08:48:27 GMT

OMG (!)

Solution that helps me:

Subfield(1111, ' ', 1) as [Показатель ID]

topic Re: QS Feb2020 Convert String to Number | Script Error | when Concatenate Tables in App Development

QS Feb2020 Convert String to Number | Script Error | when Concatenate Tables

Re: QS Feb2020 Convert String to Number | Script Error | when Concatenate Tables

Re: QS Feb2020 Convert String to Number | Script Error | when Concatenate Tables

Re: QS Feb2020 Convert String to Number | Script Error | when Concatenate Tables